> 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.
In response to
pgsql-performance by date
|Next:||From: David Andersen||Date: 2008-07-26 21:22:09|
|Subject: Using ENUM with huge NAMEDATALEN|
|Previous:||From: Gauri Kanekar||Date: 2008-07-24 10:15:41|
|Subject: Partitioned Tables Foreign Key Constraints Problem|