On 28 November 2011 15:04, Lukasz Brodziak <lukasz.brodziak@xxxxxxxxx> wrote:
Hello,Is it possible for sequence to decrement its value by itself? Or is it possible to see wether it was changed by someone. The thing is that on one of our clinet's DB sequence rolled back to the state from 8 months ago.
--
Łukasz Brodziak
Hi Łukasz,
you can have set the sequence as cycled (http://www.postgresql.org/docs/current/static/sql-createsequence.html) so it can set automatically to minvalue when reaching maxvalue.
Show us the definition of that sequence.
regards
Szymon
