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

From Thomas Kellerer
Subject Re: Sequence Incrementing by 2 insted of 1
Date
Msg-id gt6711$kmp$1@ger.gmane.org
Whole thread Raw
In response to Sequence Incrementing by 2 insted of 1  (David <david@vanlaatum.id.au>)
List pgsql-general
David, 28.04.2009 07:48:
> Our internal task database is doing something odd in that the
> sequence is incrementing by 2 instead of 1 and I can't find any
> 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 before and 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 a reason why?
>

My first guess would be rolled back transactions

Thomas

pgsql-general by date:

Previous
From: David
Date:
Subject: Sequence Incrementing by 2 insted of 1
Next
From: Brad Budge
Date:
Subject: Prepare / Execute Method Error