Re: [HACKERS] Reference on partial data

2009-04-19 Thread Andrew Dunstan
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

[HACKERS] Reference on partial data

2009-04-19 Thread mito
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