Antonio Garca (agarcia(at)at4(dot)net) 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