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.