Postgres Pro
Downloads
Home   >   mailing lists

Re: Changing sequence cache - Mailing list pgsql-sql

From Tom Lane
Subject Re: Changing sequence cache
Date
Msg-id 9164.1015283793@sss.pgh.pa.us
Whole thread Raw
In response to Changing sequence cache  (Matthew Price <pricem@juno.com>)
Responses Re: Changing sequence cache  ("Andrew G. Hammond" <drew@xyzzy.dhs.org>)
List pgsql-sql
Tree view 
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 by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: Uniqueness of rule, constraint, and trigger names
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: Uniqueness of rule, constraint, and trigger names