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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
