Re: pgsql: Add strict_multi_assignment and too_many_rows plpgsql checks

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Tomas Vondra <tomas(dot)vondra(at)postgresql(dot)org>
Subject: Re: pgsql: Add strict_multi_assignment and too_many_rows plpgsql checks
Date: 2019-05-09 09:12:09
Message-ID: CAFj8pRAUgAhgc=z_RasOuv+-gTPCocd-uXdw=L_orVv8T7cUyA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

Hi

čt 9. 5. 2019 v 8:52 odesílatel Peter Eisentraut <
peter(dot)eisentraut(at)2ndquadrant(dot)com> napsal:

> On 2018-07-25 01:47, Tomas Vondra wrote:
> > Add strict_multi_assignment and too_many_rows plpgsql checks
>
> Could you clarify this error message:
>
> /* translator: %s represents a name of an extra check */
> errdetail("%s check of %s is active.",
> "strict_multi_assignment",
> strict_multiassignment_level == ERROR ? "extra_errors" :
> "extra_warnings"),
>
> What does, for example,
>
> strict_multi_assignment check of extra_errors is active.
>
> mean?
>
>
strict_multi_assignment is a name of plpgsql extra check. This check checks
number of expressions against number of target variables.
extra checks can produces errors or warnings - so second placeholder
specifies used level.

The sense of this detail's message is a introduce of reason of this error
message.

Regards

Pavel

> Also note that the translator comment is only mentioning one of the %s.
>
> --
> Peter Eisentraut http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Etsuro Fujita 2019-05-09 09:42:22 pgsql: postgres_fdw: Fix cost estimation for aggregate pushdown.
Previous Message Thomas Munro 2019-05-09 08:38:45 pgsql: Fix SxactGlobalXmin tracking.

Browse pgsql-hackers by date

  From Date Subject
Next Message Etsuro Fujita 2019-05-09 09:52:38 Re: postgres_fdw: another oddity in costing aggregate pushdown paths
Previous Message Masahiko Sawada 2019-05-09 08:49:12 Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS)