[GENERAL] foreign key lost

[mikeo]

hi, i accidently deleted a foreign key trigger from pg_trigger
and now cannot get at the table.  i get the message:

ERROR:  RelationBuildTriggers: 1 record(s) not found for rel feature_code

can anyone give me a shovel :)

or a little help to get out of this please?

TIA,
  mikeo

Re: [GENERAL] foreign key lost

[Tom Lane]

mikeo [EMAIL PROTECTED] writes:
 hi, i accidently deleted a foreign key trigger from pg_trigger

Did you reach into pg_trigger and delete the record yourself, or did
a system bug cause the problem?

 and now cannot get at the table.  i get the message:
 ERROR:  RelationBuildTriggers: 1 record(s) not found for rel feature_code
 can anyone give me a shovel :)
 or a little help to get out of this please?

You'll need to tweak the table's pg_class entry so that its reltriggers
column shows the same number of triggers that are actually there for it
in pg_trigger.  A quick "UPDATE pg_class" should get you out of it.

regards, tom lane

Re: [GENERAL] foreign key lost

[mikeo]

thanks, i just discovered that before i got your message.
now that i have that shovel, maybe i should whack myself
with it!!!  :)

thanks again,
mikeo


At 02:34 PM 7/7/00 -0400, Tom Lane wrote:
mikeo [EMAIL PROTECTED] writes:
 hi, i accidently deleted a foreign key trigger from pg_trigger

Did you reach into pg_trigger and delete the record yourself, or did
a system bug cause the problem?

 and now cannot get at the table.  i get the message:
 ERROR:  RelationBuildTriggers: 1 record(s) not found for rel feature_code
 can anyone give me a shovel :)
 or a little help to get out of this please?

You'll need to tweak the table's pg_class entry so that its reltriggers
column shows the same number of triggers that are actually there for it
in pg_trigger.  A quick "UPDATE pg_class" should get you out of it.

   regards, tom lane