Re: [HACKERS] [BUGS] BUG #14759: insert into foreign data partitionsfail - Mailing list pgsql-hackers

From Etsuro Fujita
Subject Re: [HACKERS] [BUGS] BUG #14759: insert into foreign data partitionsfail
Date
Msg-id 76479f01-6af9-7968-3845-9ca179e568a7@lab.ntt.co.jp
Whole thread Raw
In response to Re: [HACKERS] [BUGS] BUG #14759: insert into foreign data partitions fail  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Responses Re: [HACKERS] [BUGS] BUG #14759: insert into foreign data partitionsfail
List pgsql-hackers
On 2017/08/01 10:18, Amit Langote wrote:
> Good points; fixed in the updated patch.

I should have mentioned this in an earlier mail, but one thing I noticed 
is this:

-    the remote server.
+    the remote server.  That becomes especially important if the table is
+    being used in a partition hierarchy, where it is recommended to add
+    a constraint matching the partition constraint expression on
+    the remote table.

I think this would apply to CHECK constraints on foreign tables when 
implementing partitioning with inheritance.  Why do we only mention this 
for partition constraints?

Other than that, the patch looks good to me.

Best regards,
Etsuro Fujita




pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: [HACKERS] A bug in mapping attributes in ATExecAttachPartition()
Next
From: Noah Misch
Date:
Subject: Re: [HACKERS] Subscription code improvements