Changing sequence cache

From: Matthew Price <pricem(at)juno(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Changing sequence cache
Date: 2002-03-04 18:02:37
Message-ID: 20020304.130237.19811.60399@wm7.jersey.juno.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Dan Langille 2002-03-04 18:32:01 Re: Changing sequence cache
Previous Message Janning Vygen 2002-03-04 13:49:35 Re: thinking about versioning my database schema