Re: proposal: plpgsql, new check for extra_errors - strict_expr_check

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Kirk Wolak <wolakk(at)gmail(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: proposal: plpgsql, new check for extra_errors - strict_expr_check
Date: 2025-07-31 05:45:28
Message-ID: CAFj8pRAzvqs3T-j43j3ewqMN2R2CdOu3qyYOu5Fd5fh+KoQAcg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi

st 30. 7. 2025 v 0:17 odesílatel Kirk Wolak <wolakk(at)gmail(dot)com> napsal:

> The following review has been posted through the commitfest application:
> make installcheck-world: tested, passed
> Implements feature: tested, passed
> Spec compliant: not tested
> Documentation: tested, passed
>
> This is properly isolated, only available when turned on.
> I ran this through the examples as specified. Then through OUR 1,000 +
> procedures.
> I used \set ON_ERROR_STOP 'on'
> and loaded a script that recreates all of our procedures/functions.
> In both modes. And it found nothing. (As expected, but that is 1,000
> procedures from the wild).
> I forced 1 procedure to have the problem.
> As expected, when enabled, this STOPPED and pointed out the error.
> Without this setting, the code loaded clean.
>
> Small note: The doc says this check is allowed only when
> plpgsql.extra_errors is set to "strict_expr_check"...
> But it also is obviously in effect when that is set to 'all' for reasons
> that should be completely obvious.
>

I removed this sentence from doc. Now, it is consistent with other plpgsql
extra checks.

>
> The new status of this patch is: Ready for Committer
>

thank you for review

updated patch attached (only documentation was changed, one sentence
removed)

Regards

Pavel

Attachment Content-Type Size
v20250731-0001-use-strict-rules-for-parsing-PL-pgSQL-expressions.patch text/x-patch 17.0 KB
v20250731-0002-simply-check-of-strict-expr-check-on-regress-test.patch text/x-patch 17.2 KB
v20250731-0003-set-plpgsql.extra_errors-to-none.patch text/x-patch 17.1 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrey Borodin 2025-07-31 06:29:25 Re: IPC/MultixactCreation on the Standby server
Previous Message Peter Smith 2025-07-31 05:45:23 Re: [WIP]Vertical Clustered Index (columnar store extension) - take2