Changing sequence cache

Поиск
Список
Период
Сортировка
От Matthew Price
Тема Changing sequence cache
Дата
Msg-id 20020304.130237.19811.60399@wm7.jersey.juno.com
обсуждение исходный текст
Ответы Re: Changing sequence cache  ("Dan Langille" <dan@langille.org>)
Re: Changing sequence cache  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
Howdy,

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?

Trying:
update customer_custid_seq set cache=5;
Gives this:
ERROR:  You can't change sequence relation customer_custid_seq

Thanks for any help,
Matthew



________________________________________________________________
GET INTERNET ACCESS FROM JUNO!
Juno offers FREE or PREMIUM Internet access for less!
Join Juno today!  For your FREE software, visit:
http://dl.www.juno.com/get/web/.


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

Предыдущее
От: Janning Vygen
Дата:
Сообщение: Re: thinking about versioning my database schema
Следующее
От: "Dan Langille"
Дата:
Сообщение: Re: Changing sequence cache