pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_prepared_statements missing column
4+ messages / 3 participants
[nested] [flat]
Commits from this thread:
2022-11-13 f754e7600a Doc: remove pg_prepared_statements.result_types from v15 docs.
* pg_prepared_statements missing column
@ 2022-11-13 07:37 Peter Gigowski <gigawowski@gmail.com>
2022-11-13 12:54 ` Re: pg_prepared_statements missing column Julien Rouhaud <rjuju123@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Peter Gigowski @ 2022-11-13 07:37 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_prepared_statements missing column
2022-11-13 07:37 pg_prepared_statements missing column Peter Gigowski <gigawowski@gmail.com>
@ 2022-11-13 12:54 ` Julien Rouhaud <rjuju123@gmail.com>
2022-11-13 12:58 ` Re: pg_prepared_statements missing column Julien Rouhaud <rjuju123@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Julien Rouhaud @ 2022-11-13 12:54 UTC (permalink / raw)
To: Peter Gigowski <gigawowski@gmail.com>; +Cc: pgsql-bugs@lists.postgresql.org; bruce@momjian.us
Hi,
On Sat, Nov 12, 2022 at 11:37:34PM -0800, Peter Gigowski wrote:
>
> 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.
Indeed! It's a documentation bug. This was apparently an oversight
when packpatching 5766443695d (Bruce in Cc), as it introduced the result_types
column in the documentation in pg15 while the feature itself is only introduced
in pg16 (84ad713cf85).
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_prepared_statements missing column
2022-11-13 07:37 pg_prepared_statements missing column Peter Gigowski <gigawowski@gmail.com>
2022-11-13 12:54 ` Re: pg_prepared_statements missing column Julien Rouhaud <rjuju123@gmail.com>
@ 2022-11-13 12:58 ` Julien Rouhaud <rjuju123@gmail.com>
2022-11-13 15:39 ` Re: pg_prepared_statements missing column Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Julien Rouhaud @ 2022-11-13 12:58 UTC (permalink / raw)
To: Peter Gigowski <gigawowski@gmail.com>; +Cc: pgsql-bugs@lists.postgresql.org; bruce@momjian.us
On Sun, Nov 13, 2022 at 08:54:56PM +0800, Julien Rouhaud wrote:
> Hi,
>
> On Sat, Nov 12, 2022 at 11:37:34PM -0800, Peter Gigowski wrote:
> >
> > 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.
>
> Indeed! It's a documentation bug. This was apparently an oversight
> when packpatching 5766443695d (Bruce in Cc), as it introduced the result_types
> column in the documentation in pg15 while the feature itself is only introduced
> in pg16 (84ad713cf85).
I forgot to mention that I didn't check for any other new system view
introduced in pg16, between pg15 branching and 5766443695d. If there were they
whould likely be present in the pg15 version of the doc too.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_prepared_statements missing column
2022-11-13 07:37 pg_prepared_statements missing column Peter Gigowski <gigawowski@gmail.com>
2022-11-13 12:54 ` Re: pg_prepared_statements missing column Julien Rouhaud <rjuju123@gmail.com>
2022-11-13 12:58 ` Re: pg_prepared_statements missing column Julien Rouhaud <rjuju123@gmail.com>
@ 2022-11-13 15:39 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2022-11-13 15:39 UTC (permalink / raw)
To: Julien Rouhaud <rjuju123@gmail.com>; +Cc: Peter Gigowski <gigawowski@gmail.com>; pgsql-bugs@lists.postgresql.org; bruce@momjian.us
Julien Rouhaud <rjuju123@gmail.com> writes:
> On Sun, Nov 13, 2022 at 08:54:56PM +0800, Julien Rouhaud wrote:
>> Indeed! It's a documentation bug. This was apparently an oversight
>> when packpatching 5766443695d (Bruce in Cc),
Yeah, looks that way.
> I forgot to mention that I didn't check for any other new system view
> introduced in pg16, between pg15 branching and 5766443695d. If there were they
> whould likely be present in the pg15 version of the doc too.
I did some diff'ing and couldn't identify any other discrepancies.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2022-11-13 15:39 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-11-13 07:37 pg_prepared_statements missing column Peter Gigowski <gigawowski@gmail.com>
2022-11-13 12:54 ` Julien Rouhaud <rjuju123@gmail.com>
2022-11-13 12:58 ` Julien Rouhaud <rjuju123@gmail.com>
2022-11-13 15:39 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox