Re: sequence caches - Mailing list pgsql-general

From Rod Taylor
Subject Re: sequence caches
Date
Msg-id 1053465271.21079.33.camel@jester
Whole thread Raw
In response to Re: sequence caches  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Tue, 2003-05-20 at 14:50, Tom Lane wrote:
> Rod Taylor <rbt@rbt.ca> writes:
> > ALTER SEQUENCE in CVS Tip does not clear the sequence cache when
> > alterations have been made, although it certainly could.
>
> And you would persude other backends to clear their caches how?

Good question -- but setval clears the local cache, so I figure I should
probably do at least that for ALTER SEQUENCE ... RESTART WITH ? .

--
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

Attachment

pgsql-general by date:

Previous
From: "Dean Gibson (DB Administrator)"
Date:
Subject: Re: Subqueries and the optimizer
Next
From: Stephan Szabo
Date:
Subject: Re: Subqueries and the optimizer