Re: [GENERAL] Monitoring the sequence cycles

2009-08-20 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > I'm looking for a way to track the wrap arounds of cycle sequences. > > I also c

Re: [GENERAL] Monitoring the sequence cycles

2009-08-19 Thread Marc Mamin
> 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. The sequences are expected to

Re: [GENERAL] Monitoring the sequence cycles

2009-08-19 Thread Sam Mason
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 writ

[GENERAL] Monitoring the sequence cycles

2009-08-19 Thread Marc Mamin
Hello, I'm looking for a way to track the wrap arounds of cycle sequences. I also couldn't find the view/catalog where sequence definitions are kept; this could be a good place to store at least the timestamp of the last wrap around. I'm looking for a way to log all wrap arounds, thought I gue