Skip site navigation (1) Skip section navigation (2)

Drop table doesn't drop serial sequences.

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Drop table doesn't drop serial sequences.
Date: 2000-10-13 10:44:49
Message-ID: 200010131044.e9DAinG51711@hub.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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


pgsql-bugs by date

Next:From: Bruce MomjianDate: 2000-10-14 04:36:46
Subject: Re: PostgreSQL BugTool Submission
Previous:From: Bruce MomjianDate: 2000-10-12 19:00:36
Subject: Re: INSERT/SELECT with ORDER BY

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group