Thread: pg_catalog.pg_proc procedure has correct proargnames array, but proargtypes is empty
The following function's metadata is not correctly reported in the pg_proc table (see picture below).
CREATE OR REPLACE FUNCTION scm.get_period_type_adjustment(period_type_id integer)
RETURNS numeric
LANGUAGE plpgsql
IMMUTABLE
AS $function$
------
begin
return (case
when period_type_id in (1) then 1.0
when period_type_id in (2, 17, 4, 3) then 0.25
when period_type_id = 10 then 0.5
else 1
end)::numeric;
end;
$function$
;
RETURNS numeric
LANGUAGE plpgsql
IMMUTABLE
AS $function$
------
begin
return (case
when period_type_id in (1) then 1.0
when period_type_id in (2, 17, 4, 3) then 0.25
when period_type_id = 10 then 0.5
else 1
end)::numeric;
end;
$function$
;
--
Walker Philips
Data Engineering Consultant
Saguaro Capital Management
Attachment
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.
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