Re: Removing constraints

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Nathan Barnett" <nbarnett(at)cellularphones(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Removing constraints
Date: 2000-11-13 18:04:41
Message-ID: 10134.974138681@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Nathan Barnett" <nbarnett(at)cellularphones(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Roger Wernersson 2000-11-13 18:12:51 RE: 7.0.3 RPMs?
Previous Message Lamar Owen 2000-11-13 17:56:56 Re: 7.0.3 RPMs?