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

From Scott Marlowe
Subject Re: Sequence Incrementing by 2 insted of 1
Date
Msg-id dcc563d10904280001n13857088xe50ab33b5db850db@mail.gmail.com
Whole thread Raw
In response to Re: Sequence Incrementing by 2 insted of 1  (David <david@vanlaatum.id.au>)
Responses Re: Sequence Incrementing by 2 insted of 1
List pgsql-general
On Tue, Apr 28, 2009 at 12:38 AM, David <david@vanlaatum.id.au> wrote:
> Looked for that can't find anything and there is no reason why someone would have added that.

Well, unless you've got some example code for us to look at, it's
kinda hard to tell you what's wrong.

Often, you see people do something like this:

insert into autoincrementingtable values (DEFAULT, 'a', 500);
select nextval('autoinctable_seq');
yada yada yada

or something like that.  i.e. there's an implicit call to the nextval
with the insert, and another explicit one somewhere in your code.

pgsql-general by date:

Previous
From: David
Date:
Subject: Re: Sequence Incrementing by 2 insted of 1
Next
From: David
Date:
Subject: Re: Sequence Incrementing by 2 insted of 1