Incorrect number of rows inserted into partitioned table

From: Роман Осипов <osipovromanvladimirovich(at)gmail(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Incorrect number of rows inserted into partitioned table
Date: 2023-04-10 18:42:28
Message-ID: CAAqk126uv_J-T8MhOvMqmUUD6MPsxFpq=zojDnWeftZokDYyEw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Good afternoon

When reloading data from a simple table into a partitioned (through
inheritance) using a query like:* insert into [new_partition_table] select
* from [old_table] limit xxxxxxx*;

There is an insertion not of the amount specified in *limit*,, but a little
more or less than it.

SQL queries in attachment

Attachment Content-Type Size
Test-limit.sql application/octet-stream 1.2 KB

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David Rowley 2023-04-10 21:36:16 Re: Incorrect number of rows inserted into partitioned table
Previous Message Daniel Gustafsson 2023-04-10 18:33:45 Re: BUG #17866: behavior does not match documentation