On Wed, Jul 13, 2022 at 7:58 AM André Hänsel <andre@xxxxxxxx> wrote:
SELECT last_value FROM t_id_seq;
This will yield “8”, showing that new sequence numbers have been generated for each attempt.
Yep, an entire able-to-be-inserted tuple is formed every time. That requires evaluating defaults so that every column has a value.
David J.