[HACKERS] Unique functional index and FK constraints

2002-11-11 Thread Kris Jurka
Tom, When you restructured the unique index location and validation for foreign key constraints around 9/22 you added the restriction that the supporting unique index may not be functional. I believe that this restriction is not necessary. Suppose I had a unique index on LOWER(login). That

Re: [HACKERS] Unique functional index and FK constraints

2002-11-11 Thread Tom Lane
Kris Jurka [EMAIL PROTECTED] writes: When you restructured the unique index location and validation for foreign key constraints around 9/22 you added the restriction that the supporting unique index may not be functional. I believe that this restriction is not necessary. Hmm ... I'm not