On Wed, Mar 28, 2018 at 6:58 AM, Amit Langote <langote_amit...@lab.ntt.co.jp> wrote: >> which violates the constraint on the column b (ie, b > 0), so this >> should abort. The reason for that is because CopyFrom looks at the >> parent relation's constraints, not the partition's constraints, when >> checking the constraint against the input row. > > Good catch, thanks! >
+1 >> Attached is a patch for fixing this issue. > > That looks good to me. This one would need to be back-patched to v10. Thanks. Please add to the next commitfest so that it doesn't get lost. We can not add this to v11 open items since it isn't a v11 bug exactly. -- Best Wishes, Ashutosh Bapat EnterpriseDB Corporation The Postgres Database Company