Re: Dropping tables

Ron Peterson wrote:
>
> Hrvoje Niksic wrote:
> >
> > DROP TABLE does not seem to allow me to fully drop a table.  Example:
> >
> > test=# CREATE TABLE x (id SERIAL);
> > NOTICE:  CREATE TABLE will create implicit sequence 'x_id_seq' for SERIAL column 'x.id'
> > NOTICE:  CREATE TABLE/UNIQUE will create implicit index 'x_id_key' for table 'x'CREATE
> >
> > Huh?  What is this?  Oh, x_id_key somehow survived DROP TABLE.
> > Bummer.  Maybe I can use DROP INDEX to drop it?
>
> Close.  Try DROP SEQUENCE.

And this is a known gotcha (I now actually consider it a feature, if a bit unintuitive):

http://www.postgresql.org/docs/postgres/datatype.htm#AEN946

Regards,
Ed Loehr