BUG #16446: ERROR: virtual tuple table slot does not have system attributes on insert to partitioned table - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #16446: ERROR: virtual tuple table slot does not have system attributes on insert to partitioned table
Date
Msg-id 16446-2011a4b103fc5fd1@postgresql.org
Whole thread Raw
List pgsql-bugs
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.


pgsql-bugs by date:

Previous
From: Kurt Roeckx
Date:
Subject: Re: BUG #16443: Too much memory usage on insert query
Next
From: Sandeep Thakkar
Date:
Subject: Re: BUG #16428: pg_ctl unusable after standard install