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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--