Re: Auto DROP SEQUENCE?

Please see below:

> -----Original Message-----
> From: frbn [mailto:frbn(at)efbs-seafrigo(dot)fr]
> Sent: Thursday, July 25, 2002 9:27 AM
> To: Daryl Beattie
> Cc: 'pgsql-general(at)postgresql(dot)org'
> Subject: Re: [GENERAL] Auto DROP SEQUENCE?
>
>
> Daryl Beattie a écrit:
> > 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. :)
>
> a sequence can be used by more than one table.
>
> I presume it's the reason why seq are not dropped.
>

Yes, it can.

But a sequnce that is automatically generated using the SERIAL data type
*should not* be used by more than one table. The SERIAL type abstracts the
sequence away from the SQL user so that the user might not even really know
that SERIAL is implemented using a sequence. The fact that a SERIAL is a
sequence is an implementation detail, right? And as such, perhaps those
sequences should be dropped with the table.

If my reasoning is incorrect, please correct me.

Sincerely,

Daryl.