remove "msg" parameter from convert_tuples_by_name - Mailing list pgsql-hackers

From Alvaro Herrera
Subject remove "msg" parameter from convert_tuples_by_name
Date
Msg-id 20190806224728.GA17233@alvherre.pgsql
Whole thread Raw
Responses Re: remove "msg" parameter from convert_tuples_by_name  (Amit Langote <amitlangote09@gmail.com>)
List pgsql-hackers
Hello, here's a pretty trivial cleanup.

Currently, you have to pass the errmsg text to convert_tuples_by_name
and convert_tuples_by_position that's going to be raised if the tuple
descriptors don't match.  In the latter's case that makes sense, as each
case is pretty specific and tailored messages can be offered, so this is
useful.

However, in the case of convert_tuples_by_name, it seems we don't have
enough control over what is being called, so there's no way to
produce tailored messages -- all the callers are using the same generic
wording: "could not convert row type".

This code was introduced by dcb2bda9b704; I think back then we were
thinking that it would be possible to give different error messages for
different cases (as convert_tuples_by_position was already doing then),
however it seems clear now that that'll never happen.

I propose we get rid of it by having convert_tuples_by_name supply the
error message by itself, as in the attached patch.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Attachment

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [Proposal] Table-level Transparent Data Encryption (TDE) and KeyManagement Service (KMS)
Next
From: Ryan Lambert
Date:
Subject: Re: FETCH FIRST clause PERCENT option