Auto DROP SEQUENCE?

From: Daryl Beattie <dbeattie(at)insystems(dot)com>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Auto DROP SEQUENCE?
Date: 2002-07-23 16:00:36
Message-ID: 4160E6FC08ABD21191F000805F857E9304DF4560@mail.insystems.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi PostgreSQL people,

I was wondering; I have noticed that sequences are not dropped
automatically if they are used by a table. That's okay; I bet somebody has a
good reason why this is so. However, when sequences are created implicitly
by somebody using the SERIAL data type, does it not make sense to drop that
sequence when the table is dropped?
I'm just throwing the question out. :)

Thanks,

Daryl.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2002-07-23 16:01:08 Re: Problem between inheritance and references
Previous Message Stephane Bortzmeyer 2002-07-23 15:43:40 Re: Problem between inheritance and references