Re: updates for handling optional argument in system functions

From: Mark Wong <markwkm(at)gmail(dot)com>
To: Andreas Karlsson <andreas(at)proxel(dot)se>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: updates for handling optional argument in system functions
Date: 2026-04-08 18:10:55
Message-ID: adaaL5VD9bfipZQI@ltdrgnflg2
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Apr 08, 2026 at 01:51:30AM +0200, Andreas Karlsson wrote:
> On 4/8/26 1:42 AM, Mark Wong wrote:
> > I don't see any matches when I grep for rule_oid or pretty_bool...
>
> Sorry for the noise, I was looking at an old version of the docs. The
> parameters do indeed match the docs. But now that I looked at the
> patches again I found a real issue which I think should be fixed.

No worries.

> I think the following:
>
> "select statement of a view with pretty-print option"
>
> should likely just be:
>
> "select statement of a view"

Yeah, I agree with that considering that other functions like the recent
get_*_ddl functions have options like that aren't detailed in
pg_proc.dat.

What I pondered over a little bit was whether to flip-flop and remove
the original _ext definitions instead and modify their respective
counterparts that I originally removed. I opted to continue editing what
I started because of the comment that reads "System-view support
functions with pretty-print option", but I don't have any strong
opinions either way.

I've attached v7 with the more succinct descriptions.

Regards,
Mark

Attachment Content-Type Size
v7-0001-Handle-pg_get_ruledef-default-args-in-system_func.patch text/plain 2.6 KB
v7-0002-Handle-pg_get_viewdef-default-args-in-system_func.patch text/plain 4.1 KB
v7-0003-Handle-pg_get_indexdef-default-args-in-system_fun.patch text/plain 2.8 KB
v7-0004-Handle-pg_get_constraintdef-default-args-in-syste.patch text/plain 2.8 KB
v7-0005-Handle-pg_get_expr-default-args-in-system_functio.patch text/plain 3.5 KB
v7-0006-Handle-pg_get_triggerdef-default-args-in-system_f.patch text/plain 2.5 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Sami Imseih 2026-04-08 18:14:42 Re: Add pg_stat_autovacuum_priority
Previous Message Fujii Masao 2026-04-08 18:09:12 Re: Use SIGTERM instead of SIGUSR1 for slotsync worker to exit during promotion?