Search Postgresql Archives

Re: Sequence Incrementing by 2 insted of 1

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, Apr 28, 2009 at 12:38 AM, David <david@xxxxxxxxxxxxxxx> 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.

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux