Can you give the sequence of commands you used and the
version?
The easiest way to get rid of the message is to set the
reltriggers for the pg_class row associated to invoice
to the correct number. It seems like the number of triggers
got updated but the triggers themselves were never added.
Stephan Szabo
[EMAIL PROTECTED]
On Tue, 5 Dec 2000, Sivagami . wrote:
> Hi,
>
> I have a question. I tried adding a Foreign Key constraint to a table via the ALTER
>TABLE command. But the records in the table did not match with those in the Parent
>table. Now my Alter table command, instead of giving me an error of kind - 'records
>do not match', has gone into a kind of Deadlock between the 2 tables. I am not able
>to select from the tables, nor delete them, nor drop them. If I try to do any of
>these, I get the error saying -
> " Error : RelationBuildTriggers: 2 record(s) not found for rel invoice"
>
> How do I overcome this error. Any ideas will be greatly appreciated.
> Thanks a lot in advance.
>
> Shiva.
>
>
