Re: BUG #15967: Sequence generation using NEXTVAL() fails on 64bit systems

We also had problems to reproduce it outside of the application, but are still working on an independent test script.

One special case is, that the application uses prepared statements for all queries, also for the NEXTVAL() selection.

Christoph

Am 20. August 2019 15:44:55 MESZ schrieb Jeff Janes <jeff(dot)janes(at)gmail(dot)com>:
>>
>>
>> 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