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
>