Re: Partitioned Tables Foreign Key Constraints Problem - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Partitioned Tables Foreign Key Constraints Problem
Date
Msg-id 488A545B.4070609@agliodbs.com
Whole thread Raw
In response to Partitioned Tables Foreign Key Constraints Problem  ("Gauri Kanekar" <meetgaurikanekar@gmail.com>)
List pgsql-performance
Gauri,

> How can we define the Foreign_key constraint on "other_tbl" based upon
> any partitioned table field.

Currently PostgreSQL doesn't have any simple way to support this.  There
are a few workarounds, but they're fairly awkward, such as a trigger to
check if the ID is correct.

--Josh


pgsql-performance by date:

Previous
From: "Gauri Kanekar"
Date:
Subject: Partitioned Tables Foreign Key Constraints Problem
Next
From: "David Andersen"
Date:
Subject: Using ENUM with huge NAMEDATALEN