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  ("Andrew G. Hammond" <drew@xyzzy.dhs.org>)
Список 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 по дате отправления:

Предыдущее
От: "Josh Berkus"
Дата:
Сообщение: Re: Uniqueness of rule, constraint, and trigger names
Следующее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: Uniqueness of rule, constraint, and trigger names