Re: Changing sequence cache

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Changing sequence cache
Дата
Msg-id 9164.1015283793@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Changing sequence cache  (Matthew Price <pricem@juno.com>)
Ответы Re: Changing sequence cache
Список pgsql-sql
Matthew Price <pricem@juno.com> writes:
> I already have a sequence named customers_custid_seq
> I would like to increase the cache setting some.  How can i alter the cache after the sequence has already been
created?

You can't, but there's no reason you shouldn't drop and recreate the
sequence.
        regards, tom lane


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