Re: Partitioned Tables Foreign Key Constraints Problem

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Gauri Kanekar <meetgaurikanekar(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Partitioned Tables Foreign Key Constraints Problem
Date: 2008-07-25 22:31:55
Message-ID: 488A545B.4070609@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message David Andersen 2008-07-26 21:22:09 Using ENUM with huge NAMEDATALEN
Previous Message Gauri Kanekar 2008-07-24 10:15:41 Partitioned Tables Foreign Key Constraints Problem