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 convinced. What about functions that return NULL for some inputs? A unique index will not reject multiple NULL entries. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html