Re: Auto DROP SEQUENCE? - Mailing list pgsql-general

From frbn
Subject Re: Auto DROP SEQUENCE?
Date
Msg-id 3D3FFCA5.1090304@efbs-seafrigo.fr
Whole thread Raw
In response to Auto DROP SEQUENCE?  (Daryl Beattie <dbeattie@insystems.com>)
List pgsql-general
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.




pgsql-general by date:

Previous
From: "Mario Weilguni"
Date:
Subject: Re: select distinct error ?
Next
From: "Marc G. Fournier"
Date:
Subject: Re: erserver