Re: Changing sequence cache

On 4 Mar 2002 at 18:02, Matthew Price wrote:

> 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

test=# create sequence mprice;
CREATE

test=# select nextval('mprice');
nextval
---------
1
(1 row)

test=# select setval('mprice', 23);
setval
--------
23
(1 row)

test=# select nextval('mprice');
nextval
---------
24
(1 row)

test=#
--
Dan Langille
The FreeBSD Diary - http://freebsddiary.org/ - practical examples