Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #15967: Sequence generation using NEXTVAL() fails on 64bit systems - Mailing list pgsql-bugs

From Jeff Janes
Subject Re: BUG #15967: Sequence generation using NEXTVAL() fails on 64bit systems
Date
Msg-id CAMkU=1w7BtrvqghRdeJ1WGeeiP5UKhMYLAXxBuKR7JaSfuYsew@mail.gmail.com
Whole thread Raw
In response to BUG #15967: Sequence generation using NEXTVAL() fails on 64bit systems  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #15967: Sequence generation using NEXTVAL() fails on 64bit systems  (Merlin Moncure <mmoncure@gmail.com>)
Re: BUG #15967: Sequence generation using NEXTVAL() fails on 64bit systems  (Christoph Ziegenberg <ziegenberg@web.de>)
List pgsql-bugs
Tree view

I did many tests:
 
Can you include the code which implements those tests? 

I can't reproduce with something like this:

perl -e 'use DBI; fork; fork; fork; my $dbh=DBI->connect("dbi:Pg:host=/tmp"); for (1..1e6) {my $seq = $dbh->selectrow_array("select nextval('\''foo_seq'\'')"); $dbh->do("insert into foo values (?)",undef,$seq);}'

Cheers,

Jeff

pgsql-bugs by date:

Previous
From: Dave Cramer
Date:
Subject: Re: BUG #15957: Connection event listener not called during close()
Next
From: Merlin Moncure
Date:
Subject: Re: BUG #15967: Sequence generation using NEXTVAL() fails on 64bit systems