Re: [HACKERS] TODO list request: FK to unique expression indexes

2008-11-20 Thread Robert Haas
> Allowing foreign keys to point to expression indexes seems to open a can > of worms and I am not sure there is enough demand to warrant it. It does open a can of worms. I've often wanting something related, which is the ability to make a foreign key references a PARTIAL index. ...Robert -- S

Re: [HACKERS] TODO list request: FK to unique expression indexes

2008-11-20 Thread Bruce Momjian
David E. Wheeler wrote: > On Nov 19, 2008, at 9:12 AM, Josh Berkus wrote: > > > Folks, > > > > Since it's too late to look at this for 8.4, can the following go on > > the TODO list? > > > > Referential Integrity > > > > [] Allow creation of FKs targeting unique expression indexes on the > > r

Re: [HACKERS] TODO list request: FK to unique expression indexes

2008-11-19 Thread David E. Wheeler
On Nov 19, 2008, at 9:12 AM, Josh Berkus wrote: Folks, Since it's too late to look at this for 8.4, can the following go on the TODO list? Referential Integrity [] Allow creation of FKs targeting unique expression indexes on the referenced table. Syntax: REFERENCES ( ( column express