Re: Foreign keys and partitioned tables - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Foreign keys and partitioned tables
Date
Msg-id 8a3e483c-d89f-6872-74ac-5f0ee36357eb@2ndquadrant.com
Whole thread Raw
In response to Re: Foreign keys and partitioned tables  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: Foreign keys and partitioned tables
List pgsql-hackers
On 3/29/18 23:19, Alvaro Herrera wrote:
> 0001 prohibits having foreign keys pointing to partitioned tables, as
> discussed above.

This is already prohibited.  You get an error

ERROR:  cannot reference partitioned table "fk_partitioned_pk"

Your patch 0001 just adds the same error check a few lines above the
existing one, while 0003 removes the existing one.

I think you can squash 0001 and 0003 together.

> 0002 is a fixup for a bug in the row triggers patch: I had a restriction
> earlier that triggers declared internal were not cloned, and I seem to
> have lost it in rebase.  Reinstate it.

Hmm, doesn't cause any test changes?

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: [HACKERS][PATCH] adding simple sock check for windows
Next
From: Amit Kapila
Date:
Subject: Re: hot_standby_feedback vs excludeVacuum and snapshots