Re: notice about costly ri checks (2) - Mailing list pgsql-patches

From Tom Lane
Subject Re: notice about costly ri checks (2)
Date
Msg-id 11681.1078523755@sss.pgh.pa.us
Whole thread Raw
In response to Re: notice about costly ri checks (2)  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Responses Re: notice about costly ri checks (2)
List pgsql-patches
Stephan Szabo <sszabo@megazone.bigpanda.com> writes:
>> Why should we make them guess which column is the problem, when we know
>> it perfectly well?

> As a side question, if there are multiple cross-type conversions in one
> constraint on different column pairs, what do we think the message should
> be? One message with multiple column mentions in detail or multiple
> notices?  (I haven't looked at the patch to see if one or the other is
> easier with how it's set up)

I would expect it to generate one WARNING for each mismatch; doing
anything else would make life a lot more complex, both as to writing the
code and as to formatting the output readably.

            regards, tom lane

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Updated version of contrib/xml (at last)
Next
From: "Lee Kindness"
Date:
Subject: ECPG: Update tests & memory leak fix