Horton

Re: generating function default settings from pg_proc.dat

Michael Paquier <michael@paquier.xyz>

View thread View on postgr.es
From: Michael Paquier <michael@paquier.xyz>
To: Andres Freund <andres@anarazel.de>
Cc: Andrew Dunstan <andrew@dunslane.net>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2026-02-16T23:19:45Z
Lists: pgsql-hackers 
On Mon, Feb 16, 2026 at 01:54:49PM -0500, Andres Freund wrote:
> On 2026-02-16 12:31:37 -0500, Andrew Dunstan wrote:
>> Motivated by Bug 19409 [1] I decided to do something about a wart that has
>> bugged me for a while, namely the requirement to write stuff in
>> system_views.sql if you need to specify default values for function
>> arguments.
> 
> I'm one more person this has been bugging.

Please add me on the stack of people who have been annoyed by that
largely more than once.  Glad to see that this could be enforced in
the bki scripts.
--
Michael

Commits

  1. Simplify creation of built-in functions with non-default ACLs.

  2. Be more wary of false matches in initdb's replace_token().

  3. Simplify creation of built-in functions with default arguments.