Re: [PATCH] Add result_types column to pg_prepared_statements view

Peter Eisentraut <peter.eisentraut@enterprisedb.com>

From: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
To: Dagfinn Ilmari Mannsåker <ilmari@ilmari.org>, Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers@lists.postgresql.org
Date: 2022-07-05T05:34:24Z
Lists: pgsql-hackers
On 01.07.22 14:27, Dagfinn Ilmari Mannsåker wrote:
> Peter Eisentraut <peter.eisentraut@enterprisedb.com> writes:
> 
>> On 19.05.22 17:34, Dagfinn Ilmari Mannsåker wrote:
>>> Prompted by a question on IRC, here's a patch to add a result_types
>>> column to the pg_prepared_statements view, so that one can see the types
>>> of the columns returned by a prepared statement, not just the parameter
>>> types.
>>> I'm not quite sure about the column name, suggestions welcome.
>>
>> I think this patch is sensible.

> The arguments about client-side type-specific value handling for
> RowDescription don't apply here IMO, since this view is more
> user-facing.

I agree.  It's also easy to change if needed.  Committed as is.



Commits

  1. Add result_types column to pg_prepared_statements view

  2. In RowDescription messages, report columns of domain datatypes as having