gusdev-gusdev

[GUSDEV] Creating new Schema rules

[<hen...@gm...>]

Hello everyone,

Is there any nomenclature, or number I should follow for naming a
rule? How do I access them? I'm creating new views, and I want to
incorporate the rules that already present in other views. Other thing
I was wondering was if I replace a view, keeping its current name,=20
does it lose any rules currently related to it?


Thanks in advance,


Henrique Cesar Lemos Juc=E1 - http://www.bioinformatica.ufsc.br

"As soon as you concern yourself with the "good" and "bad" of your fellows,=
=20
you create an opening in your heart for maliciousness to enter. Testing,=20
competing with, and criticizing others weaken and defeat you."

Morihei Ueshiba, O-Sensei (1883-1969)

Re: [GUSDEV] Creating new Schema rules

[Michael S. <msa...@pc...>]

Hi Henrique,

I'm not sure what you mean by "rule"-- are you talking about constraints,
triggers, or something else (PostgreSQL has a notion of rules that are
functionally very similar to triggers-- is this what you're referring to?

--Mike


On 8/25/05 4:28 PM, "Henrique Juc=E1" <hen...@gm...> wrote:

> Hello everyone,
>=20
> Is there any nomenclature, or number I should follow for naming a
> rule? How do I access them? I'm creating new views, and I want to
> incorporate the rules that already present in other views. Other thing
> I was wondering was if I replace a view, keeping its current name,
> does it lose any rules currently related to it?
>=20
>=20
> Thanks in advance,
>=20
>=20
> Henrique Cesar Lemos Juc=E1 - http://www.bioinformatica.ufsc.br
>=20
> "As soon as you concern yourself with the "good" and "bad" of your fellow=
s,
> you create an opening in your heart for maliciousness to enter. Testing,
> competing with, and criticizing others weaken and defeat you."
>=20
> Morihei Ueshiba, O-Sensei (1883-1969)
>=20
>=20
> -------------------------------------------------------
> SF.Net email is Sponsored by the Better Software Conference & EXPO
> September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practic=
es
> Agile & Plan-Driven Development * Managing Projects & Teams * Testing & Q=
A
> Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
> _______________________________________________
> Gusdev-gusdev mailing list
> Gus...@li...
> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev

Re: [GUSDEV] Creating new Schema rules

[Steve F. <sfi...@pc...>]

henrique-

i am wondering why you are creating new views.   normally, the gus=20
schema doesn't require that.

what views are you creating and why?

steve

Henrique Juc=E1 wrote:

>Hello everyone,
>
>Is there any nomenclature, or number I should follow for naming a
>rule? How do I access them? I'm creating new views, and I want to
>incorporate the rules that already present in other views. Other thing
>I was wondering was if I replace a view, keeping its current name,=20
>does it lose any rules currently related to it?
>
>
>Thanks in advance,
>
>
>Henrique Cesar Lemos Juc=E1 - http://www.bioinformatica.ufsc.br
>
>"As soon as you concern yourself with the "good" and "bad" of your fello=
ws,=20
>you create an opening in your heart for maliciousness to enter. Testing,=
=20
>competing with, and criticizing others weaken and defeat you."
>
>Morihei Ueshiba, O-Sensei (1883-1969)
>
>
>-------------------------------------------------------
>SF.Net email is Sponsored by the Better Software Conference & EXPO
>September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practi=
ces
>Agile & Plan-Driven Development * Managing Projects & Teams * Testing & =
QA
>Security * Process Improvement & Measurement * http://www.sqe.com/bsce5s=
f
>_______________________________________________
>Gusdev-gusdev mailing list
>Gus...@li...
>https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
> =20
>

[GUSDEV] Re: Creating new Schema rules and views

[<hen...@gm...>]

Hi Steve,


I tried uploading the file you provided in your email (at least part of it)=
,=20
and I got the following error:
(this WARNING repeats several times)

---------------------------------------------------

-------------------- WARNING ---------------------
MSG: Unexpected error in feature table for Skipping feature, attempting to=
=20
recover
---------------------------------------------------

-------------------- WARNING ---------------------
MSG: Unexpected error in feature table for Skipping feature, attempting to=
=20
recover
---------------------------------------------------

ERROR:
Can't call method "genus" on an undefined value at=20
/usr/local/GUS/gus_home/lib/perl/GUS/Supported/Plugin/InsertSequenceFeature=
s.pm=20
line 812, <GEN29> line 1473.

STACK TRACE:
at=20
/usr/local/GUS/gus_home/lib/perl/GUS/Supported/Plugin/InsertSequenceFeature=
s.pm=20
line 812
GUS::Supported::Plugin::InsertSequenceFeatures::getTaxonId('GUS::Supported:=
:Plugin::InsertSequenceFeatures=3DHASH(0x87071b0)',
'Bio::Seq::RichSeq=3DHASH(0x9414818)') called at=20
/usr/local/GUS/gus_home/lib/perl/GUS/Supported/Plugin/InsertSequenceFeature=
s.pm=20
line 587
GUS::Supported::Plugin::InsertSequenceFeatures::constructNASequence('GUS::S=
upported::Plugin::InsertSequenceFeatures=3DHASH(0x87071b0)',
'Bio::Seq::RichSeq=3DHASH(0x9414818)', 3734) called at=20
/usr/local/GUS/gus_home/lib/perl/GUS/Supported/Plugin/InsertSequenceFeature=
s.pm=20
line 547
GUS::Supported::Plugin::InsertSequenceFeatures::bioperl2NASequence('GUS::Su=
pported::Plugin::InsertSequenceFeatures=3DHASH(0x87071b0)',
'Bio::Seq::RichSeq=3DHASH(0x9414818)') called at=20
/usr/local/GUS/gus_home/lib/perl/GUS/Supported/Plugin/InsertSequenceFeature=
s.pm=20
line 348
GUS::Supported::Plugin::InsertSequenceFeatures::run('GUS::Supported::Plugin=
::InsertSequenceFeatures=3DHASH(0x87071b0)',
'HASH(0x91cf374)') called at=20
/usr/local/GUS/gus_home/lib/perl/GUS/PluginMgr/GusApplication.pm line 469
eval {...} called at=20
/usr/local/GUS/gus_home/lib/perl/GUS/PluginMgr/GusApplication.pm line 461
GUS::PluginMgr::GusApplication::doMajorMode_RunOrReport('GUS::PluginMgr::Gu=
sApplication=3DHASH(0x81bac20)',
'GUS::Supported::Plugin::InsertSequenceFeatures', 1) called at=20
/usr/local/GUS/gus_home/lib/perl/GUS/PluginMgr/GusApplication.pm line 380
GUS::PluginMgr::GusApplication::doMajorMode_Run('GUS::PluginMgr::GusApplica=
tion=3DHASH(0x81bac20)',
'GUS::Supported::Plugin::InsertSequenceFeatures') called at=20
/usr/local/GUS/gus_home/lib/perl/GUS/PluginMgr/GusApplication.pm line 288
GUS::PluginMgr::GusApplication::doMajorMode('GUS::PluginMgr::GusApplication=
=3DHASH(0x81bac20)',
'GUS::Supported::Plugin::InsertSequenceFeatures') called at=20
/usr/local/GUS/gus_home/lib/perl/GUS/PluginMgr/GusApplication.pm line 197
GUS::PluginMgr::GusApplication::parseAndRun('GUS::PluginMgr::GusApplication=
=3DHASH(0x81bac20)',
'ARRAY(0x81ce520)') called at /usr/local/GUS/gus_home/bin/ga line 1


When I did the build, as you instructed, I did not recreate the schema.=20
Should I do that?


Thanks,


Henrique Cesar Lemos Juc=E1 - http://www.bioinformatica.ufsc.br

"As soon as you concern yourself with the "good" and "bad" of your fellows,=
=20
you create an opening in your heart for maliciousness to enter. Testing,=20
competing with, and criticizing others weaken and defeat you."

Morihei Ueshiba, O-Sensei (1883-1969)