Drop table doesn't drop serial sequences. - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject Drop table doesn't drop serial sequences.
Date
Msg-id 200010131044.e9DAinG51711@hub.org
Whole thread Raw
List pgsql-bugs
Antonio García (agarcia@at4.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
tablefails 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

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: INSERT/SELECT with ORDER BY
Next
From: Bruce Momjian
Date:
Subject: Re: PostgreSQL BugTool Submission