Horton
Menu

Re: Postgres Bug (ALTER TABLE problem)

Joel Burton <jburton@scw.org>

View thread
From: Joel Burton <jburton@scw.org>
To: Boulat Khakimov <boulat@inet-interactif.com>
Cc: pgsql-general@postgresql.org
Date: 2001-04-26T18:59:54Z
Lists: pgsql-general 
On Thu, 26 Apr 2001, Boulat Khakimov wrote:

> Hi,
> 
> I've discovered a bug in Postgres. When you rename 
> a table, the corresponding triggers for that table 
> are not updated.

Yep.

Use ALTER TABLE ADD CONSTRAINT to add 'em back in.

More info can be found in the Ref Int tutorial I just submitted at
techdocs.postgresql.org.

HTH,
-- 
Joel Burton   <jburton@scw.org>
Director of Information Systems, Support Center of Washington