Thread: foreign key lost
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
mikeo <mikeo@spectrumtelecorp.com> 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
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 <mikeo@spectrumtelecorp.com> 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 >