Stephan Szabo <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend