Allow specifying NULL default in pg_proc.dat for "any" arguments

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Allow specifying NULL default in pg_proc.dat for "any" arguments
Date: 2026-03-06 15:07:30
Message-ID: 6d776769-e5e4-45f8-a87a-c2be04f01f76@dunslane.net
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


I noticed a small gap in our recent addition of default arguments for
functions in pg_proc.dat - it chokes if you try to set the default for a
VARIADIC "any" argument. But there's no need if the default argument us
NULL, as it often is. We don't need the argument's type_io_data etc. in
such a case. So this patch just handles NULL without fetching any type info.

cheers

andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com

Attachment Content-Type Size
0001-Allow-NULL-defaults-for-pseudo-type-parameters-in-pg.patch text/x-patch 1.9 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Melanie Plageman 2026-03-06 15:22:10 Re: Mis-use of type BlockNumber?
Previous Message David Steele 2026-03-06 15:01:04 Re: Improve checks for GUC recovery_target_xid