At 00:28 02/11/01 +0000, you wrote: >I am new to postgres and am in the process of creating a new database of >several 100 tables. Most of the tables have a serial datatype. When the >table is created psql says it is creating an implicit sequence. Yet >when I drop the table and even when I drop the database the sequence is >still there. When I try to re-create the table it fails beacuse the >sequence already exists. This same behaviour exists for indexes. How >can I get rid of any sequences or indexes that have been created. I >would prefer not to explicitly drop each one. Ideally I would like to >drop the table and have all related indexes, sequences dropped.
pgAdmin2 knows how to drop indexes when dropping a table: http://pgadmin.postgresql.org It might not be interesting to drop a sequence as it can be used by multiple tables. Dave: do you think pgAdmin2 should drop a sequence when dropping a table? Best regards, Jean-Michel POURE
