Re: Postgres Bug (ALTER TABLE problem)

From: Joel Burton <jburton(at)scw(dot)org>
To: Boulat Khakimov <boulat(at)inet-interactif(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres Bug (ALTER TABLE problem)
Date: 2001-04-26 18:59:54
Message-ID: Pine.LNX.4.21.0104261458570.1139-100000@olympus.scw.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)scw(dot)org>
Director of Information Systems, Support Center of Washington

In response to

Browse pgsql-general by date

  From Date Subject
Next Message will trillich 2001-04-26 19:01:46 Re: crypt(table.field) ?
Previous Message Joel Burton 2001-04-26 18:53:18 Re: Re: Need for newbie friendly docs (was Newbie struggling...)