Re: Postgres Bug (ALTER TABLE problem) - Mailing list pgsql-general

From Joel Burton
Subject Re: Postgres Bug (ALTER TABLE problem)
Date
Msg-id Pine.LNX.4.21.0104261458570.1139-100000@olympus.scw.org
Whole thread Raw
In response to Postgres Bug (ALTER TABLE problem)  (Boulat Khakimov <boulat@inet-interactif.com>)
List 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


pgsql-general by date:

Previous
From: will trillich
Date:
Subject: Re: crypt(table.field) ?
Next
From: Joel Burton
Date:
Subject: Re: Re: Need for newbie friendly docs (was Newbie struggling...)