Re: Removing constraints - Mailing list pgsql-general

From Tom Lane
Subject Re: Removing constraints
Date
Msg-id 10134.974138681@sss.pgh.pa.us
Whole thread Raw
In response to RE: Removing constraints  ("Nathan Barnett" <nbarnett@cellularphones.com>)
List pgsql-general
"Nathan Barnett" <nbarnett@cellularphones.com> writes:
> Thanks for the initial help.  I followed your instructions, but now I'm
> getting an error: "ERROR:  RelationBuildTriggers: 2 record(s) not found for
> rel nametable".  Where else would these triggers be referenced.

If you manually add/delete triggers for a relation, you have to also
manually update the trigger count field in its entry in pg_class.

            regards, tom lane

pgsql-general by date:

Previous
From: Lamar Owen
Date:
Subject: Re: 7.0.3 RPMs?
Next
From: Roger Wernersson
Date:
Subject: RE: 7.0.3 RPMs?