Re: sequence caches

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: sequence caches
Дата
Msg-id 1053465271.21079.33.camel@jester
обсуждение исходный текст
Ответ на Re: sequence caches  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: "Dean Gibson (DB Administrator)"
Дата:
Сообщение: Re: Subqueries and the optimizer
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Subqueries and the optimizer