From: | David <david(at)vanlaatum(dot)id(dot)au> |
---|---|
To: | Daniel Verite <daniel(at)manitou-mail(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org, ian(at)niw(dot)com(dot)au |
Subject: | Re: Sequence Incrementing by 2 insted of 1 |
Date: | 2009-04-28 07:36:14 |
Message-ID: | 20090428073614.GD17477@daboyz.dyndns.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Cool thanks that makes sense was hard to pin down because we didn't notice for a while.
On Tue, Apr 28, 2009 at 09:31:26AM +0200, Daniel Verite wrote:
> David wrote:
>
> >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?
>
> I'd say rewrite rules are your prime suspect.
> Check out for example:
> http://archives.postgresql.org/pgsql-sql/2007-03/msg00334.php
>
> Cordialement,
> --
> Daniel
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
From | Date | Subject | |
---|---|---|---|
Next Message | Sam Mason | 2009-04-28 08:42:24 | Re: Query organization question |
Previous Message | Daniel Verite | 2009-04-28 07:31:26 | Re: Sequence Incrementing by 2 insted of 1 |