> 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.  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.)

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to