Re: serial sequences not automatically dropped - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: serial sequences not automatically dropped
Date
Msg-id 20011210130658.X70079-100000@megazone23.bigpanda.com
Whole thread Raw
In response to serial sequences not automatically dropped  (mcornell@spamcop.net (mcornell))
List pgsql-sql
On 7 Dec 2001, mcornell wrote:

> We're new to postgres and using it on Linux and OS X. We've had to
> change our code to work around what looks like a bug: When a table
> that contains a SERIAL column is dropped, the corresponding sequence
> for that column is *not* dropped. This is a pain, because we are
> trying to support multiple RDBMSs, and only postgres requires this. It
> seems like it should be keeping track of which columns are serial and
> drop them when the table is dropped. Please tell us: Any plans to
> address this in the near future? Thanks!

There's been discussion about this in the past. This will probably be
dealt with as soon as we start doing a more meaningful list of what
objects depend on what other objects. Right now, there's no good way
to make sure that the sequence isn't being refered to from something
else, and I'm not sure what the correct behavior would be in that
case (probably depends on the whole restrict/cascade thing I guess).





pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: Replacing "LIKE" with "="
Next
From: Stephan Szabo
Date:
Subject: Re: Can anybody help me with SQL?