On 2019-08-26 13:28, Daniel Migowski wrote:
> I would like to implement a fallback solution
> that detects such errors and automatically updates the nextvalue of the
> sequence when the nextvalue is already used on insert.
ISTM that such a system would likely have many of the same problems as
the often-proposed ignore-errors mode for COPY, namely that you can't
catch errors and do something else other than rethrowing the error.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services