Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_catalog.pg_proc procedure has correct proargnames array, but proargtypes is empty - Mailing list pgsql-bugs

From Walker Philips
Subject Re: pg_catalog.pg_proc procedure has correct proargnames array, but proargtypes is empty
Date
Msg-id CAFssDwnKhGFcE2cXGo+9F1k-SuUTGRgSfzgDc_jsaQo-gMLhoA@mail.gmail.com
Whole thread Raw
In response to Re: pg_catalog.pg_proc procedure has correct proargnames array, but proargtypes is empty  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view
PostgreSQL 14.4 (Ubuntu 14.4-1.pgdg22.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.2.0-19ubuntu1) 11.2.0, 64-bit

I'm using DBeaver as my IDE. The column does appear to be oidvector. Other functions seem to come through ok weirdly enough. It potentially might be a visual glitch with DBeaver based on the following screenshot. Still pretty odd. I can submit to DBeaver if that might be the underlying issue.

image.png
image.png


On Fri, Jul 15, 2022 at 7:54 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
David Rowley <dgrowleyml@gmail.com> writes:
> Can you share which version of PostgreSQL you see this on?

Hmm ... looking more closely, it's definitely not stock PG,
because proargtypes is oidvector which would not include any
curly braces in the output.

Hard to tell what's going on exactly; seems like it could be
corrupt catalog data or faulty code modifications.  Or maybe
there's something wrong with whatever the viewing tool is?

                        regards, tom lane


--
Walker Philips
Data Engineering Consultant
Saguaro Capital Management
Attachment

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_catalog.pg_proc procedure has correct proargnames array, but proargtypes is empty
Next
From: Tom Lane
Date:
Subject: Re: pg_catalog.pg_proc procedure has correct proargnames array, but proargtypes is empty