Re: Notice about costly ri checks - Mailing list pgsql-patches

From Fabien COELHO
Subject Re: Notice about costly ri checks
Date
Msg-id Pine.LNX.4.58.0403031624570.28778@sablons.cri.ensmp.fr
Whole thread Raw
In response to Re: Notice about costly ri checks  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
> > 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.

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 - coelho@cri.ensmp.fr

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Notice about costly ri checks
Next
From: Fabien COELHO
Date:
Subject: notice about costly ri checks (2)