Re: Auto DROP SEQUENCE?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Daryl Beattie <dbeattie(at)insystems(dot)com>
Cc: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Auto DROP SEQUENCE?
Date: 2002-07-25 15:25:21
Message-ID: 18689.1027610721@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Daryl Beattie <dbeattie(at)insystems(dot)com> writes:
> 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?

Try it in CVS tip ;-)

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2002-07-25 15:28:13 Re: erserver
Previous Message Tom Lane 2002-07-25 15:22:53 Re: select distinct error ?