> > This patch adds a "notice" at constraint creation time if the referential
> > integrity check is to be "costly", that is the comparison operator
> > involves some coercion.
>
> This is not the correct test at all.
Advertising
You mean my morning 5mn programming will not be enough? ;-)
> The correct test would involve
> looking in pg_amop to see if the selected operator is a member of the
> opclass for the referenced column's index. (IIRC there are helper
> functions in lsyscache.c that will make this easier.)
Ok, I'll have a look.
--
Fabien Coelho - [EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
