OK, updated.
---
Stephen Frost wrote:
-- Start of PGP signed section.
> * Bruce Momjian (pgman@candle.pha.pa.us) wrote:
> > Added to TODO:
> >
> > o Have ALTER INDEX update the name of a constraint using that index
* Bruce Momjian (pgman@candle.pha.pa.us) wrote:
> Added to TODO:
>
> o Have ALTER INDEX update the name of a constraint using that index
> o Allow ALTER TABLE RENAME CONSTRAINT
More like:
Add ALTER TABLE RENAME CONSTRAINT; implicitly rename linked indexes also
Is there much depen
Added to TODO:
o Have ALTER INDEX update the name of a constraint using that index
o Allow ALTER TABLE RENAME CONSTRAINT
---
Tom Lane wrote:
> Stephen Frost <[EMAIL PROTECTED]> writes:
> > * Tom Lane ([EMAI
Stephen Frost <[EMAIL PROTECTED]> writes:
> * Tom Lane ([EMAIL PROTECTED]) wrote:
>> Arguably we should forbid ALTER INDEX RENAME on an index that belongs to
>> a constraint, and make you rename the constraint instead (and have that
>> implicitly change the index name too).
> That would work too,
* Tom Lane ([EMAIL PROTECTED]) wrote:
> Stephen Frost <[EMAIL PROTECTED]> writes:
> > test=> create table a (
> > test(> b int primary key
> > test(> );
> > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "a_pkey" for=
> > table "a"
> > CREATE TABLE
> > test=> alter table a r
Stephen Frost <[EMAIL PROTECTED]> writes:
> test=> create table a (
> test(> bint primary key
> test(> );
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "a_pkey" for=
> table "a"
> CREATE TABLE
> test=> alter table a rename to c;
> ALTER TABLE
> test=> alter index a_pke
