| From: | frbn <frbn(at)efbs-seafrigo(dot)fr> |
|---|---|
| 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 13:27:01 |
| Message-ID: | 3D3FFCA5.1090304@efbs-seafrigo.fr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Treat | 2002-07-25 13:32:11 | Re: psql ... does not like my user ... help please ;-) |
| Previous Message | Mario Weilguni | 2002-07-25 13:14:42 | Re: select distinct error ? |