BUG #16446: ERROR: virtual tuple table slot does not have system attributes on insert to partitioned table

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #16446: ERROR: virtual tuple table slot does not have system attributes on insert to partitioned table
Дата
Msg-id 16446-2011a4b103fc5fd1@postgresql.org
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Kurt Roeckx
Дата:
Сообщение: Re: BUG #16443: Too much memory usage on insert query
Следующее
От: Sandeep Thakkar
Дата:
Сообщение: Re: BUG #16428: pg_ctl unusable after standard install