On Wed, Jul 13, 2022 at 7:58 AM André Hänsel <andre(at)webkr(dot)de> 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.