posgres 12 bug (partitioned table)

From: Pavel Biryukov <79166341370(at)yandex(dot)ru>
To: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: posgres 12 bug (partitioned table)
Date: 2020-06-04 10:50:07
Message-ID: 141051591267657@mail.yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

<div>Hello!</div><div>On postgres 12.3 the problem still exists (<a href="https://www.postgresql.org/message-id/16446-2011a4b103fc5fd1%40postgresql.org">https://www.postgresql.org/message-id/16446-2011a4b103fc5fd1%40postgresql.org</a>):</div><div> </div><div>(Tested on PostgreSQL 12.3 (Debian 12.3-1.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit)</div><div> </div><div><div><div>Bug reference:      16446</div><div>Logged by:          Георгий Драк</div><div>Email address:      sonicgd(at)gmail(dot)com</div><div>PostgreSQL version: 12.2</div><div>Operating system:   Debian 10.3</div><div>Description:        </div><div> </div><div> </div><div>Hello. I'm catch error "virtual tuple table slot does not have system</div><div>attributes" when inserting row into partitioned table with RETURNING xmin;</div><div> </div><div> </div><div>Reproduction.</div><div> </div><div> </div><div>1. Create schema</div><div>CREATE TABLE "tmp"</div><div>(</div><div>    id   bigint generated always as identity,</div><div>    date timestamptz not null,</div><div>    foo  int         not null,</div><div>    PRIMARY KEY ("id", "date")</div><div>)</div><div>    PARTITION BY RANGE ("date");</div><div>CREATE TABLE "tmp_2020" PARTITION OF "tmp" FOR VALUES FROM ('2020-01-01') TO</div><div>('2021-01-01');</div><div> </div><div> </div><div>2. Execute query</div><div>INSERT INTO "tmp" ("date", "foo")</div><div>VALUES (NOW(), 1)</div><div>RETURNING id, xmin;</div><div> </div><div> </div><div>3. Result - ERROR: virtual tuple table slot does not have system</div><div>attributes</div><div> </div><div> </div><div>4. Expected result - id and xmin of inserted row.</div><div> </div></div></div>

Attachment Content-Type Size
unknown_filename text/html 1.7 KB

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2020-06-04 13:58:16 BUG #16479: Error installing pg-admin3
Previous Message Nanda Christanto 2020-06-04 09:56:46 Re: BUG #16478: Unable to edit and delete for certain row manually using db beaver

Browse pgsql-hackers by date

  From Date Subject
Next Message Mahendra Singh Thalor 2020-06-04 11:35:50 Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions
Previous Message movead.li@highgo.ca 2020-06-04 09:49:25 Re: proposal - function string_to_table