Postgres Pro
Downloads
Home   >   mailing lists

Re: Remove mention in docs that foreign keys on partitioned tablesare not supported - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Remove mention in docs that foreign keys on partitioned tablesare not supported
Date
Msg-id CA+TgmoaauLOesotZDfVVxX8UFaQrVAB9vb7N6Mgi4WiL9sK5GQ@mail.gmail.com
Whole thread Raw
In response to Re: Remove mention in docs that foreign keys on partitioned tables are not supported  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Remove mention in docs that foreign keys on partitioned tables are not supported
List pgsql-hackers
Tree view 
On Mon, Jun 4, 2018 at 1:42 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Could we solve it by saying that triggers on partitioned tables aren't
> allowed to change the partitioning values?  (Or at least, not allowed
> to change them in a way that changes the target partition.)

That seems like a somewhat-unfortunate restriction.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Юрий Соколов
Date:
Subject: Re: New committers announced at PGCon 2018
Next
From: Tom Lane
Date:
Subject: Re: Remove mention in docs that foreign keys on partitioned tables are not supported