Re: Auto DROP SEQUENCE?

Поиск
Список
Период
Сортировка
От frbn
Тема Re: Auto DROP SEQUENCE?
Дата
Msg-id 3D3FFCA5.1090304@efbs-seafrigo.fr
обсуждение исходный текст
Ответ на Auto DROP SEQUENCE?  (Daryl Beattie <dbeattie@insystems.com>)
Список 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 по дате отправления:

Предыдущее
От: "Mario Weilguni"
Дата:
Сообщение: Re: select distinct error ?
Следующее
От: "Marc G. Fournier"
Дата:
Сообщение: Re: erserver