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