Horton

Re: partitioned tables referenced by FKs

Jesper Pedersen <jesper.pedersen@redhat.com>

View thread View on postgr.es
From: Jesper Pedersen <jesper.pedersen@redhat.com>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2019-03-29T16:45:35Z
Lists: pgsql-hackers

Attachments

Hi,

On 3/29/19 12:29 PM, Alvaro Herrera wrote:
> On 2019-Mar-29, Jesper Pedersen wrote:
>> Maybe the "(" / ")" in the CASCADE description should be removed from
>> ref/drop_table.sgml as part of this patch.
> 
> I'm not sure what text you propose to remove?
>

Just the attached.

>> Should catalogs.sgml be updated for this case ?
> 
> I'm not adding any new dependency type, nor modifying any existing one.
> Are you looking at anything that needs changing specifically?
> 

No, I just mentioned it if it was a requirement that the precise 
use-case for each dependency type were documented.

Best regards,
  Jesper

Commits

  1. Support foreign keys that reference partitioned tables

  2. Fix partitioned index creation bug with dropped columns

  3. Improve psql's \d display of foreign key constraints

  4. Fix dependency recording bug for partitioned PKs

  5. Add index_get_partition convenience function

  6. Restore RI trigger sanity check

  7. Foreign keys on partitioned tables