Re: [HACKERS] Sequences....

> Wow. Serious effort here.
> 
> Ryan Bradetich wrote:
> > 1. Leave it as it is now.  It works, just explain to 
> > people that sequences and tables are seperate entities, 
> > and the serial type is just a shortcut.
> 
> I dislike this approach. It seems that it is hiding detail
> that is necessary for proper maintence.  It isn't that
> hard to type in the code.  IMHO, the shortcut causes more
> confusion that it helps.  So, I propose a third option:
> 
> 0.  Remove the SERIAL construct.

When they create a serial, we tell them:
ltest=> create table testx(x serial);NOTICE:  CREATE TABLE will create implicit sequence testx_x_seq forSERIAL column
testx.xNOTICE: CREATE TABLE/UNIQUE will create implicit index testx_x_key fortable testxCREATE
 

So it is not so terrible to tell them they have to delete it when
finished.  We could also add a column to pg_class which tells us this
sequence was auto-created from oid 12, and remove it when we delete a
table.  Or, we could name just try to delete a sequence that has the
name of the table with _seq at the end.


--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026