Re: Index name different from constraint name

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Stephen Frost <sfrost(at)snowman(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Index name different from constraint name
Date: 2005-10-27 14:16:10
Message-ID: 200510271416.j9REGAi01331@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


OK, updated.

---------------------------------------------------------------------------

Stephen Frost wrote:
-- Start of PGP signed section.
> * Bruce Momjian (pgman(at)candle(dot)pha(dot)pa(dot)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 dependency on constraint names? If not, it'd seem like
> implementing this would be pretty straight-forward. For some reason, I
> thought there was some dependency on constraint names, but I can't
> remember what...
>
> Thanks,
>
> Stephen
>
> > ---------------------------------------------------------------------------
> >
> > Tom Lane wrote:
> > > Stephen Frost <sfrost(at)snowman(dot)net> writes:
> > > > * Tom Lane (tgl(at)sss(dot)pgh(dot)pa(dot)us) 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, though I don't think you can just rename a
> > > > constraint.
> > >
> > > Yeah, we'd need to add syntax for that, but it seems useful anyway.
> > >
> > > Plan B would be to make the ALTER INDEX RENAME update the associated
> > > constraint too, but that doesn't give you a facility to rename
> > > constraints of other types.
> > >
> > > Anyway, point is that I think we should force the index and constraint
> > > names to track each other, rather than complicating matters by
> > > supporting the situation where they are different.
> > >
> > > regards, tom lane
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 9: In versions below 8.0, the planner will ignore your desire to
> > > choose an index scan if your joining column's datatypes do not
> > > match
> > >
> >
> > --
> > Bruce Momjian | http://candle.pha.pa.us
> > pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
> > + If your life is a hard drive, | 13 Roberts Road
> > + Christ can be your backup. | Newtown Square, Pennsylvania 19073
-- End of PGP section, PGP failed!

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2005-10-27 14:24:12 Re: BUG #2002: shows version wronly
Previous Message Bruce Momjian 2005-10-27 14:13:49 Re: BUG #2000: psql does not prompt for password