Home > mailing lists

Changing sequence cache - Mailing list pgsql-sql

From	Matthew Price
Subject	Changing sequence cache
Date	March 4, 2002 16:05:55
Msg-id	20020304.130237.19811.60399@wm7.jersey.juno.com Whole thread Raw
Responses	Re: Changing sequence cache ("Dan Langille" <dan@langille.org>) Re: Changing sequence cache (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-sql

Tree view

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 by date:

From: Janning Vygen
Date: 04 March 2002, 11:54:54
Subject: Re: thinking about versioning my database schema

From: "Dan Langille"
Date: 04 March 2002, 16:33:25
Subject: Re: Changing sequence cache

Changing sequence cache - Mailing list pgsql-sql

Previous

Next