-----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 > 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. You can query: select * from sequence_name; > I'm looking for a way to log all wrap arounds, thought I honestly doubt such a feature would be added to the system catalog, but it certainly might be a nice thing to output to the logs. You might want to add your request to the wiki so it doesn't get lost: http://wiki.postgresql.org/wiki/Todo One thing you can do at the moment is track how close the sequence is getting near its maxvalue, and thus have an idea of when it is about to cycle. The check_postgres program can do this for you: http://bucardo.org/check_postgres/check_postgres.pl.html#sequence - -- Greg Sabino Mullane greg@xxxxxxxxxxxx End Point Corporation PGP Key: 0x14964AC8 200908201120 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iEYEAREDAAYFAkqNadIACgkQvJuQZxSWSsg9cQCcDm9HzBzBcQL6Yj8rKKoFDtc8 100AnikYzW4quROeThMCsBjfd7aungm2 =5uI0 -----END PGP SIGNATURE----- -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
