Re: [PATCHES] Non-colliding auto generated names

Added to TODO:

>       o Have ALTER TABLE rename SERIAL sequences

Seems we at least need this.  Doesn't dependency tracking make this
easy to do now?

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

Tom Lane wrote:
> "Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> >> I think we should stick with the existing naming convention.
>                                     ^^^^^^^^^^^^^^^^^^^^^^^^^^
> 
> > Non-colliding?
> 
> No; see above.
> 
> > Otherwise, it'd be ludicrous to fail a table rename because
> > a sequence with the new name already exists...
> 
> Why?  We already rename the table's rowtype, ergo you can fail a table
> rename because there is a conflicting datatype name.  I don't see
> anything much wrong with failing a table or column rename because there
> is a conflicting sequence name.  The whole point here is to have a
> non-surprising mapping between the names of serial columns and the names
> of their associated sequences.
> 
>             regards, tom lane
> 

--  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,
Pennsylvania19073