On 28 November 2011 15:04, Lukasz Brodziak <lukasz.brodz...@gmail.com>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
