pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedserial sequences not automatically dropped
2+ messages / 2 participants
[nested] [flat]
* serial sequences not automatically dropped
@ 2001-12-07 18:44 mcornell <mcornell@spamcop.net>
2001-12-10 21:09 ` Re: serial sequences not automatically dropped Stephan Szabo <sszabo@megazone23.bigpanda.com>
0 siblings, 1 reply; 2+ messages in thread
From: mcornell@spamcop.net @ 2001-12-07 18:44 UTC (permalink / raw)
To: pgsql-sql
Hi Folks,
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!
matt
mcornell@spamcop.net
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: serial sequences not automatically dropped
2001-12-07 18:44 serial sequences not automatically dropped mcornell <mcornell@spamcop.net>
@ 2001-12-10 21:09 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
0 siblings, 0 replies; 2+ messages in thread
From: Stephan Szabo @ 2001-12-10 21:09 UTC (permalink / raw)
To: mcornell <mcornell@spamcop.net>; +Cc: 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).
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-12-10 21:09 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-12-07 18:44 serial sequences not automatically dropped mcornell <mcornell@spamcop.net>
2001-12-10 21:09 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
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