Re: Schema variables - new implementation for Postgres 15

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Dmitry Dolgov <9erthalion6(at)gmail(dot)com>
Cc: Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>, Sergey Shinderuk <s(dot)shinderuk(at)postgrespro(dot)ru>, Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>, Julien Rouhaud <rjuju123(at)gmail(dot)com>, dean(dot)a(dot)rasheed(at)gmail(dot)com, er(at)xs4all(dot)nl, joel(at)compiler(dot)org, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Schema variables - new implementation for Postgres 15
Date: 2024-02-20 19:29:29
Message-ID: CAFj8pRCToV4rqhU7p=Loa2n6WjgqiXKcOdq9Hdo+W-2YkYNUGA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

here is new rebase of this patch set.

Years ago I promised to implement support for transactional behaviour. I
wrote it in patch 0019. It is based on my patch from 2020 but the memory
cleaning is more readable and I believe it is correct. All other patches
are without touching. The first five patches are of "should to have" type,
all others (with new one) are "nice to have" type (although support for
simply expr evaluation or parallel execution has strong benefits).

Regards

Pavel

Attachment Content-Type Size
v20240220-0016-GUC-session_variables_ambiguity_warning.patch text/x-patch 13.6 KB
v20240220-0018-this-patch-changes-error-message-column-doesn-t-exis.patch text/x-patch 29.1 KB
v20240220-0017-expression-with-session-variables-can-be-inlined.patch text/x-patch 4.2 KB
v20240220-0014-allow-parallel-execution-queries-with-session-variab.patch text/x-patch 11.3 KB
v20240220-0015-plpgsql-implementation-for-LET-statement.patch text/x-patch 13.7 KB
v20240220-0013-allow-read-an-value-of-session-variable-directly-fro.patch text/x-patch 12.0 KB
v20240220-0011-Implementation-of-DEFAULT-clause-default-expressions.patch text/x-patch 33.2 KB
v20240220-0012-Implementation-of-NOT-NULL-and-IMMUTABLE-clauses.patch text/x-patch 36.6 KB
v20240220-0009-implementation-of-temporary-session-variables.patch text/x-patch 36.7 KB
v20240220-0010-Implementation-ON-TRANSACTION-END-RESET-clause.patch text/x-patch 14.4 KB
v20240220-0008-plpgsql-tests.patch text/x-patch 16.9 KB
v20240220-0007-PREPARE-LET-support.patch text/x-patch 7.4 KB
v20240220-0006-EXPLAIN-LET-support.patch text/x-patch 8.1 KB
v20240220-0005-memory-cleaning-after-DROP-VARIABLE.patch text/x-patch 22.6 KB
v20240220-0004-DISCARD-VARIABLES.patch text/x-patch 9.6 KB
v20240220-0003-function-pg_session_variables-for-cleaning-tests.patch text/x-patch 4.6 KB
v20240220-0002-Storage-for-session-variables-and-SQL-interface.patch text/x-patch 146.9 KB
v20240220-0019-transactional-variables.patch text/x-patch 39.0 KB
v20240220-0001-Enhancing-catalog-for-support-session-variables-and-.patch text/x-patch 136.0 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2024-02-20 19:42:30 Re: BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL);
Previous Message Dilshod Urazov 2024-02-20 19:19:21 Re: Proposal: Adjacent B-Tree index