Horton

Re: BUG #15587: Partitions with ALTER TABLE ADD CONSTRAINT

Amit Langote <langote_amit_f8@lab.ntt.co.jp>

View thread View on postgr.es
From: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Jesper Pedersen <jesper.pedersen@redhat.com>, pgsql-bugs@lists.postgresql.org
Date: 2019-01-24T01:59:22Z
Lists: pgsql-bugs 
Hi,

On 2019/01/24 6:07, Alvaro Herrera wrote:
> Hello
> 
>> Are you be willing to try to fix that in HEAD if someone sends a patch? :)
> 
> Well, we can discuss it in a new thread I suppose.

Sure, a new thread on -hackers.

> Do we need
> non-inheritable constraints for that case?  I think not, but maybe I'm
> wrong.

Defining non-inheritable constraints on *partitioned* parent tables is
disallowed because they would never be checked and so pointless.  I'm not
sure if we'd want to include the regular inheritance case (ALTER TABLE
child INHERIT new_parent) in this new development, but if we do, we'll
have to arrange to skip cloning parent's non-inheritable constraints.

Thanks,
Amit

Commits

  1. Fix creation of duplicate foreign keys on partitions