From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: mcornell <mcornell@spamcop.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: serial sequences not automatically dropped
Date: Mon, 10 Dec 2001 13:09:39 -0800 (PST)
Message-ID: <20011210130658.X70079-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <e991097a.0112071044.5e59424d@posting.google.com>
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).
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sszabo@megazone23.bigpanda.com, mcornell@spamcop.net
Subject: Re: serial sequences not automatically dropped
In-Reply-To: <20011210130658.X70079-100000@megazone23.bigpanda.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox