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-10-06 05:54:09
Message-ID: CAFj8pRBryCY4LqtrPu9E_mtZYkNfZb64-MetWE0232whdOLgjA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

Hi

fresh rebase after 1a8b5b11e48a8fb086228542d1d4b379f23bdc1e

I wrote (with Jim Jones's big help) notes to proposed implementation of
session variables and to session variables topics generally.

https://wiki.postgresql.org/wiki/Implementation_of_declarative_catalog_session_variables

please, read it, and ask if there is something unclear or messy

Regards

Pavel

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2025-10-06 06:11:31 Re: Logical Replication of sequences
Previous Message Tom Lane 2025-10-06 05:53:05 Re: Should we update the random_page_cost default value?

Browse pgsql-performance by date

  From Date Subject
Previous Message David Rowley 2025-09-29 20:08:16 Re: Partition pruning is not happening (even in PG18)