Re: Sequence Incrementing by 2 insted of 1

Поиск
Список
Период
Сортировка
От Jasen Betts
Тема Re: Sequence Incrementing by 2 insted of 1
Дата
Msg-id gt6ppm$j17$2@reversiblemaps.ath.cx
обсуждение исходный текст
Ответ на Sequence Incrementing by 2 insted of 1  (David <david@vanlaatum.id.au>)
Список pgsql-general
On 2009-04-28, David <david@vanlaatum.id.au> wrote:
> Our internal task database is doing something odd in that the sequence is incrementing by 2 instead of 1 and I can't
findany reason why I have checked the  
> sequence itself to see if it had somehow got set to increment by 2 but no. The table in question has a number of both
beforeand after triggers that do  
> various bits of business logic as well as some rewrite rules to track field changes. Using 8.3.0. Can anyone think of
areason why? 

possibly a rule involves the the sequence, thus it's value is computed twice.


В списке pgsql-general по дате отправления:

Предыдущее
От: Tim Uckun
Дата:
Сообщение: Huge sample dataset for testing.
Следующее
От: mgazzo
Дата:
Сообщение: Re: PostgreSQL Hibernate Problem