Re: Monitoring the sequence cycles

Поиск
Список
Период
Сортировка
От Sam Mason
Тема Re: Monitoring the sequence cycles
Дата
Msg-id 20090819163504.GU5407@samason.me.uk
обсуждение исходный текст
Ответ на Monitoring the sequence cycles  ("Marc Mamin" <M.Mamin@intershop.de>)
Список pgsql-general
On Wed, Aug 19, 2009 at 03:53:29PM +0200, Marc Mamin wrote:
> I'm looking for a way to track the wrap arounds of cycle sequences.

How about disabling cycling and doing your own monitoring?

It seems a bit fiddly because sequence values are created "outside" of
any transaction and hence if you write something into a logging table
you're going to loose it if the transaction rolls back.

--
  Sam  http://samason.me.uk/

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: question about /etc/init.d/postgresql in PGDG
Следующее
От: Andre Lopes
Дата:
Сообщение: Wich the best way to control the logic of a web application?