Re: simulating partial fkeys.. - Mailing list pgsql-sql

From Jan Wieck
Subject Re: simulating partial fkeys..
Date
Msg-id 3EE07C96.6090400@Yahoo.com
Whole thread Raw
In response to simulating partial fkeys..  (<mallah@trade-india.com>)
List pgsql-sql
mallah@trade-india.com wrote:
> 
> 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.                                  #
#================================================== JanWieck@Yahoo.com #



pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: simulating partial fkeys..
Next
From: Richard Huxton
Date:
Subject: Re: simulating partial fkeys.. [ATTN Developers please]