Re: Changing sequence cache

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Matthew Price <pricem(at)juno(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Changing sequence cache
Date: 2002-03-04 23:16:33
Message-ID: 9164.1015283793@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Matthew Price <pricem(at)juno(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas O'Dowd 2002-03-05 02:13:21 Re: [SQL] Timestamp output
Previous Message Josh Berkus 2002-03-04 23:05:07 Re: Uniqueness of rule, constraint, and trigger names