Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group