alter table rename to ..

From: Andreas Degert <ad(at)papyrus-gmbh(dot)de>
To: pgsql-hackers(at)postgresql(dot)org
Subject: alter table rename to ..
Date: 2000-09-13 08:59:30
Message-ID: 87pum87jm5.fsf@tarzan.noname
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-hackers by date

  From Date Subject
Next Message Philip Warner 2000-09-13 09:02:22 Re: Status of new relation file naming
Previous Message Zeugswetter Andreas SB 2000-09-13 08:53:20 AW: null in constraints