Reference on partial data - Mailing list pgsql-hackers

From mito
Subject Reference on partial data
Date
Msg-id gsf3is$1upe$1@news.hub.org
Whole thread Raw
Responses Re: Reference on partial data  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Hi,
is it possible to create reference constraint only on defined subset of 
data?

Reference can be defined on column which has unique constraint. It is 
also possible to create partial unique index. So it should by possible 
to reference this column. But postgres can not see this constraint and 
raises: ERROR:  there is no unique constraint matching given keys for 
referenced table

Any ideas ???

I dont feel my self to rewrite builtin trigger function which ensures 
reference integrity.


pgsql-hackers by date:

Previous
From: mito
Date:
Subject: Recursive plpgsql function in rule
Next
From: Heikki Linnakangas
Date:
Subject: Re: Recursive plpgsql function in rule