Re: proposal: schema variables

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Jim Jones <jim(dot)jones(at)uni-muenster(dot)de>
Cc: Bruce Momjian <bruce(at)momjian(dot)us>, Dmitry Dolgov <9erthalion6(at)gmail(dot)com>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Erik Rijkers <er(at)xs4all(dot)nl>, Michael Paquier <michael(at)paquier(dot)xyz>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, DUVAL REMI <REMI(dot)DUVAL(at)cheops(dot)fr>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, jian he <jian(dot)universality(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, PegoraroF10 <marcos(at)f10(dot)com(dot)br>
Subject: Re: proposal: schema variables
Date: 2025-11-02 20:40:46
Message-ID: CAFj8pRAOTQ5BkKvCFHkUE=HWzirZhVzxE5iugbcOsz=z5R0ogA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

Hí

I rewrote the transformLetStmt routine. Now, some checks and
transformations are shared with VariableFence transformation and with
PLAssignStmt transformation (after
https://github.com/postgres/postgres/commit/b0fb2c6aa5a485e28210e13ae5536c1231b1261f
)

Although I removed redundant code, the patch 0011 is longer (4KB/58KB),
because I needed to modify another lines. But now, the code is much more
consistent (and more robust).

Regards

Pavel

Attachment Content-Type Size
v20251102-0015-plpgsql-tests.patch text/x-patch 13.6 KB
v20251102-0014-memory-cleaning-after-DROP-VARIABLE.patch text/x-patch 23.4 KB
v20251102-0013-DISCARD-VARIABLES.patch text/x-patch 10.2 KB
v20251102-0011-LET-command-assign-a-result-of-expression-to-the-ses.patch text/x-patch 57.5 KB
v20251102-0012-function-pg_get_session_variables_memory-for-cleanin.patch text/x-patch 4.9 KB
v20251102-0010-svariableReceiver.patch text/x-patch 9.0 KB
v20251102-0009-fill-an-auxiliary-buffer-with-values-of-session-vari.patch text/x-patch 19.5 KB
v20251102-0008-collect-session-variables-used-in-plan-and-assign-pa.patch text/x-patch 16.4 KB
v20251102-0007-local-HASHTAB-for-currently-used-session-variables-a.patch text/x-patch 14.1 KB
v20251102-0006-session-variable-fences-parsing.patch text/x-patch 32.2 KB
v20251102-0005-support-of-session-variables-for-pg_dump.patch text/x-patch 15.3 KB
v20251102-0004-support-of-session-variables-for-psql.patch text/x-patch 22.6 KB
v20251102-0003-GRANT-REVOKE-variable.patch text/x-patch 54.4 KB
v20251102-0002-CREATE-DROP-ALTER-VARIABLE.patch text/x-patch 80.4 KB
v20251102-0001-introduce-new-class-catalog-pg_variable.patch text/x-patch 16.3 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2025-11-02 20:56:49 Re: Making jsonb_agg() faster
Previous Message Nazir Bilal Yavuz 2025-11-02 20:35:44 Re: List TAP test files in makefiles

Browse pgsql-performance by date

  From Date Subject
Next Message Andreas Joseph Krogh 2025-11-05 08:18:06 trgm and index-usage when using similarity function
Previous Message David Rowley 2025-10-31 01:19:03 Re: GEQO plans much slower than standard join plans