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