Horton

Re: [POC] Fast COPY FROM command for the table with foreign partitions

Andrei Lepikhov <a.lepikhov@postgrespro.ru>

View thread View on postgr.es
From: "Andrey V. Lepikhov" <a.lepikhov@postgrespro.ru>
To: "Tang, Haiying" <tanghy.fnst@cn.fujitsu.com>, Amit Langote <amitlangote09@gmail.com>, "Tsunakawa, Takayuki" <tsunakawa.takay@fujitsu.com>
Cc: Alexey Kondratov <a.kondratov@postgrespro.ru>, Michael Paquier <michael@paquier.xyz>, Ashutosh Bapat <ashutosh.bapat@2ndquadrant.com>, Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>, Etsuro Fujita <etsuro.fujita@gmail.com>, PostgreSQL-Dev <pgsql-hackers@postgresql.org>
Date: 2020-12-23T09:00:18Z
Lists: pgsql-hackers

Attachments

On 12/22/20 12:04 PM, Tang, Haiying wrote:
> Hi Andrey,
> 
> There is an error report in your patch as follows. Please take a check.
> 
> https://travis-ci.org/github/postgresql-cfbot/postgresql/jobs/750682857#L1519
> 
>> copyfrom.c:374:21: error: ‘save_cur_lineno’ is used uninitialized in this function [-Werror=uninitialized]
> 
> Regards,
> Tang
> 
> 

Thank you,
see new version in attachment.

-- 
regards,
Andrey Lepikhov
Postgres Professional

Commits

  1. Allow batch insertion during COPY into a foreign table.

  2. postgres_fdw: Disable batch insertion when there are WCO constraints.

  3. Enforce foreign key correctly during cross-partition updates

  4. Fix permission checks on constraint violation errors on partitions.

  5. Fix compilation of uuid-ossp