Re: proposal: schema variables

Pavel Stehule <pavel.stehule@gmail.com>

From: Pavel Stehule <pavel.stehule@gmail.com>

To: Jim Jones <jim.jones@uni-muenster.de>

Cc: Bruce Momjian <bruce@momjian.us>, Dmitry Dolgov <9erthalion6@gmail.com>, Laurenz Albe <laurenz.albe@cybertec.at>, Erik Rijkers <er@xs4all.nl>, Michael Paquier <michael@paquier.xyz>, Amit Kapila <amit.kapila16@gmail.com>, DUVAL REMI <REMI.DUVAL@cheops.fr>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, jian he <jian.universality@gmail.com>, Alvaro Herrera <alvherre@alvh.no-ip.org>, PegoraroF10 <marcos@f10.com.br>

Date: 2025-11-02T20:40:46Z

Lists: pgsql-hackers, pgsql-performance

Attachments

v20251102-0015-plpgsql-tests.patch (text/x-patch)
v20251102-0014-memory-cleaning-after-DROP-VARIABLE.patch (text/x-patch)
v20251102-0013-DISCARD-VARIABLES.patch (text/x-patch)
v20251102-0011-LET-command-assign-a-result-of-expression-to-the-ses.patch (text/x-patch)
v20251102-0012-function-pg_get_session_variables_memory-for-cleanin.patch (text/x-patch)
v20251102-0010-svariableReceiver.patch (text/x-patch)
v20251102-0009-fill-an-auxiliary-buffer-with-values-of-session-vari.patch (text/x-patch)
v20251102-0008-collect-session-variables-used-in-plan-and-assign-pa.patch (text/x-patch)
v20251102-0007-local-HASHTAB-for-currently-used-session-variables-a.patch (text/x-patch)
v20251102-0006-session-variable-fences-parsing.patch (text/x-patch)
v20251102-0005-support-of-session-variables-for-pg_dump.patch (text/x-patch)
v20251102-0004-support-of-session-variables-for-psql.patch (text/x-patch)
v20251102-0003-GRANT-REVOKE-variable.patch (text/x-patch)
v20251102-0002-CREATE-DROP-ALTER-VARIABLE.patch (text/x-patch)
v20251102-0001-introduce-new-class-catalog-pg_variable.patch (text/x-patch)

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