Re: Sequence "self" change - possible?

Поиск
Список
Период
Сортировка
От Szymon Guz
Тема Re: Sequence "self" change - possible?
Дата
Msg-id CAFjNrYsA=fvhL0v0HMG55RsHkuj7hPCFWWfmTcaNFmu1aF1CFg@mail.gmail.com
обсуждение исходный текст
Ответ на Sequence "self" change - possible?  (Lukasz Brodziak <lukasz.brodziak@gmail.com>)
Список pgsql-admin
Дерево обсуждения


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 по дате отправления:

Предыдущее
От: Lukasz Brodziak
Дата:
Сообщение: Sequence "self" change - possible?
Следующее
От: "Oliveiros d'Azevedo Cristina"
Дата:
Сообщение: Re: Sequence "self" change - possible?