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.
________________________
Ron Peterson
rpeterson(at)yellowbank(dot)com