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