Re: Monitoring the sequence cycles - Mailing list pgsql-general

From Sam Mason
Subject Re: Monitoring the sequence cycles
Date
Msg-id 20090819163504.GU5407@samason.me.uk
Whole thread Raw
In response to Monitoring the sequence cycles  ("Marc Mamin" <M.Mamin@intershop.de>)
List 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 by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: question about /etc/init.d/postgresql in PGDG
Next
From: Andre Lopes
Date:
Subject: Wich the best way to control the logic of a web application?