Re: [HACKERS] DROPping tables with SERIALs

> Hi,
> 
> I have run into a problem dropping and re-creating tables with
> type SERIAL:
> 
> CREATE TABLE t ( s SERIAL);
> DROP TABLE t;
> CREATE TABLE t ( s SERIAL);
> 
> gives
> ERROR:  t_s_seq relation already exists
> 
> This looks like the implicitly created sequence t_s_seq is not dropped
> together with the table.
> 
> I am running a current (?) cvs snapshot from anoncvs@postgresql.org.

Added to TODO:* auto-destroy sequence on SERIAL removal


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