From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: sonicgd@gmail.com
Subject: BUG #16446: ERROR: virtual tuple table slot does not have system attributes on insert to partitioned table
Date: Mon, 18 May 2020 07:35:43 +0000
Message-ID: <16446-2011a4b103fc5fd1@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 16446
Logged by: Георгий Драк
Email address: sonicgd@gmail.com
PostgreSQL version: 12.2
Operating system: Debian 10.3
Description:
Hello. I'm catch error "virtual tuple table slot does not have system
attributes" when inserting row into partitioned table with RETURNING xmin;
Reproduction.
1. Create schema
CREATE TABLE "tmp"
(
id bigint generated always as identity,
date timestamptz not null,
foo int not null,
PRIMARY KEY ("id", "date")
)
PARTITION BY RANGE ("date");
CREATE TABLE "tmp_2020" PARTITION OF "tmp" FOR VALUES FROM ('2020-01-01') TO
('2021-01-01');
2. Execute query
INSERT INTO "tmp" ("date", "foo")
VALUES (NOW(), 1)
RETURNING id, xmin;
3. Result - ERROR: virtual tuple table slot does not have system
attributes
4. Expected result - id and xmin of inserted row.
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: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, sonicgd@gmail.com
Subject: Re: BUG #16446: ERROR: virtual tuple table slot does not have system attributes on insert to partitioned table
In-Reply-To: <16446-2011a4b103fc5fd1@postgresql.org>
* 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