Postgres Pro
Downloads
Home   >   mailing lists

Re: Sequence "self" change - possible? - Mailing list pgsql-admin

From Szymon Guz
Subject Re: Sequence "self" change - possible?
Date
Msg-id CAFjNrYsA=fvhL0v0HMG55RsHkuj7hPCFWWfmTcaNFmu1aF1CFg@mail.gmail.com
Whole thread Raw
In response to Sequence "self" change - possible?  (Lukasz Brodziak <lukasz.brodziak@gmail.com>)
List pgsql-admin
Tree view


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

pgsql-admin by date:

Previous
From: Lukasz Brodziak
Date:
Subject: Sequence "self" change - possible?
Next
From: "Oliveiros d'Azevedo Cristina"
Date:
Subject: Re: Sequence "self" change - possible?