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
