Re: dropping sequences

Поиск
Список
Период
Сортировка
От Erik Price
Тема Re: dropping sequences
Дата
Msg-id 3EF23589.8080901@ptc.com
обсуждение исходный текст
Ответ на Re: dropping sequences  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general

Tom Lane wrote:
> Erik Price <eprice@ptc.com> writes:
>
>>So, is the solution to drop the column first, then drop the sequence,
>>then re-create the column by using ALTER TABLE ?
>
>
> Perhaps what you are really looking to do is just to reset the sequence
> counters with setval() ?

Believe it or not, I really want to remove the sequences altogether.  It
may sound strange.  I'm experimenting.



Erik


В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: dropping sequences
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: dropping sequences