Re: proposal: schema variables

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: 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>, Jim Jones <jim(dot)jones(at)uni-muenster(dot)de>
Subject: Re: proposal: schema variables
Date: 2025-09-13 09:28:56
Message-ID: CAFj8pRBeF5Tz_DiKWokeEcRxrJR5FFDbTKhaaB-9TMYU3RYDfw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

Hi

minor change (after private talk with Jim Jones)

renaming function `pg_session_variables` to
`pg_get_session_variables_memory`
renaming out parameter of this function `removed` to `dropped`
+ regress test plpgsql - plpgsql routines has not strong dependency to
session variables (same dependency like to other database objects)

Regards

Pavel

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Korotkov 2025-09-13 09:35:35 Re: High CPU consumption in cascade replication with large number of walsenders
Previous Message Richard Guo 2025-09-13 09:02:04 Re: plan shape work

Browse pgsql-performance by date

  From Date Subject
Previous Message Tom Lane 2025-09-09 19:19:46 Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column