From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | sonicgd(at)gmail(dot)com |
Subject: | BUG #16446: ERROR: virtual tuple table slot does not have system attributes on insert to partitioned table |
Date: | 2020-05-18 07:35:43 |
Message-ID: | 16446-2011a4b103fc5fd1@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 16446
Logged by: Георгий Драк
Email address: sonicgd(at)gmail(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2020-05-18 07:53:31 | Re: translation typos |
Previous Message | Kurt Roeckx | 2020-05-17 16:01:50 | Re: BUG #16443: Too much memory usage on insert query |