Re: [PATCH] Add result_types column to pg_prepared_statements view

Dagfinn Ilmari Mannsåker <ilmari@ilmari.org>

From: Dagfinn Ilmari Mannsåker <ilmari@ilmari.org>
To: "Peter Eisentraut" <peter.eisentraut@enterprisedb.com>, "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers@lists.postgresql.org
Date: 2022-07-05T07:31:27Z
Lists: pgsql-hackers
On Tue, 5 Jul 2022, at 06:34, Peter Eisentraut wrote:
> 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.

Thanks!



Commits

  1. Add result_types column to pg_prepared_statements view

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