Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Performance > Re: Partitioned...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 4185 of 4424
Post > Topic >>

Re: Partitioned Tables Foreign Key Constraints Problem

by josh@[EMAIL PROTECTED] (Josh Berkus) Jul 25, 2008 at 03:31 PM

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 sup****t 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@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
 




 1 Posts in Topic:
Re: Partitioned Tables Foreign Key Constraints Problem
josh@[EMAIL PROTECTED] (  2008-07-25 15:31:55 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 21:39:00 CST 2008.