From: Tom Lane <tgl@sss.pgh.pa.us>
To: n5jgvx4@nate.sh
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16969: INSERT of multiple rows into GENERATED ALWAYS AS IDENTITY column with DEFAULT value is broken.
Date: Sat, 17 Apr 2021 11:16:11 -0400
Message-ID: <256834.1618672571@sss.pgh.pa.us> (raw)
In-Reply-To: <16969-e14b6d95e35f939c@postgresql.org>
References: <16969-e14b6d95e35f939c@postgresql.org>
PG Bug reporting form <noreply@postgresql.org> writes:
> -- insert more than one row with "id" set to DEFAULT;
> -- result: unexpected and undocumented failure with the following error:
> -- ERROR: cannot insert into column "id"
> -- DETAIL: Column "id" is an identity column defined as GENERATED
> ALWAYS.
> -- HINT: Use OVERRIDING SYSTEM VALUE to override.
> INSERT INTO test (id, name) VALUES (DEFAULT, 'Adam'), (DEFAULT, 'Eve');
Yeah, this is a known deficiency. It's fixed for v14, but the
fix was deemed too invasive to risk back-patching [1].
regards, tom lane
[1] https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=17958972f
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, n5jgvx4@nate.sh, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16969: INSERT of multiple rows into GENERATED ALWAYS AS IDENTITY column with DEFAULT value is broken.
In-Reply-To: <256834.1618672571@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox