alter table rename to .. - Mailing list pgsql-hackers

From Andreas Degert
Subject alter table rename to ..
Date
Msg-id 87pum87jm5.fsf@tarzan.noname
Whole thread Raw
List pgsql-hackers
Hi,

I'm not sure if this has been already discussed..

Renaming a database table doesn't change automatically created index
names, so that if you do

create table t(a int primary key);
alter table t rename to t1;
create table t(a int primary key);

then the second create will fail. Would it be possible to have the
alter table command to also rename the index? The same goes for
columns with unique.

ciao
Andreas


pgsql-hackers by date:

Previous
From: Zeugswetter Andreas SB
Date:
Subject: AW: null in constraints
Next
From: Tatsuo Ishii
Date:
Subject: Re: PL/pgSQL does not accept none ASCII identifiers