pg_prepared_statements missing column

From: Peter Gigowski <gigawowski(at)gmail(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: pg_prepared_statements missing column
Date: 2022-11-13 07:37:34
Message-ID: CAM7cJ6XY_PAmx0kGn6U307EKZ+qXDFEBH27WP87-_ygetnBuxQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello Devs,

My buddy and I were running through the 15.1 docs today and found the
pg_prepared_statements view doesn't include the return_type column like it
says it should.

Here is the printout from /d pg_prepared_statements
View "pg_catalog.pg_prepared_statements" Column | Type | Collation |
Nullable | Default
-----------------+--------------------------+-----------+----------+---------
name | text | | | statement | text | | | prepare_time | timestamp with time
zone | | | parameter_types | regtype[] | | | from_sql | boolean | | |
generic_plans | bigint | | | custom_plans | bigint | | |

My version:
PostgreSQL 15.1 (Debian 15.1-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled
by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit

Link to docs:
https://www.postgresql.org/docs/15/view-pg-prepared-statements.html

I'm not sure exactly what to make of it, but I wanted to submit a ticket.

Thanks for all your hard work!
-PG

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message hubert depesz lubaczewski 2022-11-13 08:06:34 Re: WAL segments removed from primary despite the fact that logical replication slot needs it.
Previous Message Mike Adelson 2022-11-12 20:18:39 RE: BUG #17686: SELECT pg_advisory_lock(...) with low lock_timeout sometimes times out but the lock is acquired