hi ,
Is there any way to enforce fkeys only on subset of the table something on the lines of unique partial indexes
Sure. Put NULL values into the referencing fields of those rows you don't want to be checked.
Jan
-- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== [EMAIL PROTECTED] #
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
