Reference on partial data

mito wrote:

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.

No, it's not.

This looks like a usage question, which doesn't belong on -hackers.
Please ask such questions on pgsql-general.

cheers

andrew