Antonio García ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Drop table doesn't drop serial sequences. Long Description The SERIAL special type automatically creates a sequence for the field when you create a table. The sequence isn't automatically dropped when you drop the table, so a new create table fails because the sequence already exists. Sample Code create table foo ( id serial ); drop table foo; create table foo ( id serial ); No file was uploaded with this report