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 > > 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 <[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, 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@candle.pha.pa.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@candle.pha.pa.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 broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
