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

On Wed, Aug 21, 2019 at 8:27 AM Christoph Ziegenberg <ziegenberg(at)web(dot)de> wrote:
>
> Good news: We finally found the error.
>
> It was a trigger on one table that updated the sequence using setval()... Of course this cannot work and I don't know why this was added (perhaps for a migration script?).
>
> This use of setval() via the trigger was missing in the Postgres statement log (perhaps because it was a PERFORM statement?), so we didn't find it earlier.
>
> Sorry and thanks for your help to all.

No worries, glad you found the issue. I mean, nextval() is probably
the most commonly trafficked function in the database and is dead
reliable for millions of users, so there had to be another
explanation, right? :-). setval() is an extremely dangerous function
outside of cases related to restoring data; it modifies state outside
of transactional guarantees. if you saw it in code not guarded by
some kind of lock you ought to be suspicious.

merlin