renaming table leaves constraint behind [7.3.2] - Mailing list 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@klawitter.de