Re: Sequence Incrementing by 2 insted of 1 - Mailing list pgsql-general

From Jasen Betts
Subject Re: Sequence Incrementing by 2 insted of 1
Date
Msg-id gt6ppm$j17$2@reversiblemaps.ath.cx
Whole thread Raw
In response to Sequence Incrementing by 2 insted of 1  (David <david@vanlaatum.id.au>)
List 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 by date:

Previous
From: Tim Uckun
Date:
Subject: Huge sample dataset for testing.
Next
From: mgazzo
Date:
Subject: Re: PostgreSQL Hibernate Problem