On Sun, Jul 12, 2015 at 4:09 AM, Yourfriend <[email protected]> wrote: > Suggestion: When a conflict was found for UPSERT, don't access the > sequence, so users can have a reasonable list of ID.
This is not technically feasible. What if the arbiter index is a serial PK? The same thing can happen when a transaction is aborted. SERIAL is not guaranteed to be gapless. -- Peter Geoghegan -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
