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
-
Hi all,
Have a problem related to partition tables.
We have the following schema's :
master -
id integer (PRIMARY KEY)
cid integer
child1, child2 are the child tables of master table. Here "cid" is the field
used for partitioning.
We have another table called
other_tbl -
id integer (PRIMARY KE
