renaming table leaves constraint behind [7.3.2]

From: Holger Klawitter <lists(at)klawitter(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: renaming table leaves constraint behind [7.3.2]
Date: 2003-02-10 18:29:50
Message-ID: 200302101929.50623.lists@klawitter.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi there,

the following code throws an error (which it didn't in 7.2.x):

CREATE TABLE a ( id int unique );
...do a lot of things with a...
ALTER TABLE a RENAME to b;

CREATE TABLE a ( id int unique ); -- fails

Is there a "clean" way to have constraints renamed along with the table? Or
this there a way to just rename the constraint?

With kind regards / mit freundlichem Gruß
Holger Klawitter
--
Holger Klawitter http://www.klawitter.de
lists(at)klawitter(dot)de

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-02-10 18:32:52 Re: upgrade from 7.3.1 to 7.3.2
Previous Message Jean-Luc Lachance 2003-02-10 18:21:03 Re: selects with large offset really slow