Postgres Pro
Downloads
Home   >   mailing lists

Re: Cannot dump foreign key constraints on partitioned table - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Cannot dump foreign key constraints on partitioned table
Date
Msg-id 20180712184537.5vjwgxlbuiomomqd@alvherre.pgsql
Whole thread Raw
In response to Re: Cannot dump foreign key constraints on partitioned table  (Michael Paquier <michael@paquier.xyz>)
Responses Re: Cannot dump foreign key constraints on partitioned table  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
Tree view 
On 2018-Jul-12, Michael Paquier wrote:

> Changing pg_class.relhastriggers is out of scope because as far as I
> know partitioned tables have no triggers, so the current value is
> correct, and that would be a catalog change at this stage which would
> cause any existing deployments of v11 to complain about the
> inconsistency.  I think that this should be fixed client-side as the
> attached does.

Thanks, looks good.  I propose to add following pg_dump test to ensure
this stays fixed.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Attachment

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: assert in nested SQL procedure call in current HEAD
Next
From: Tom Lane
Date:
Subject: Re: Cache invalidation after authentication (on-the-fly role creation)