Re: proposal: schema variables

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: 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>
Subject: Re: proposal: schema variables
Date: 2024-09-22 08:43:22
Message-ID: CAFj8pRA6nJRg8oq5k_Cdk5oH5_FjtViG8XLmHKrkqOuiMT_CKQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

Hi

fix assertion failure after
https://github.com/postgres/postgres/commit/24f5205948093a96edf8213294b3d585ac3fe1fb

the analyze routine for LetStmt was fixed

<-->/*
<--> * The query is executed as utility command by nested executor call.
<--> * Assigned queryId is required in this case.
<--> */
<-->if (IsQueryIdEnabled())

Regards

Pavel

Attachment Content-Type Size
v20240922-0017-expression-with-session-variables-can-be-inlined.patch text/x-patch 4.2 KB
v20240922-0020-pg_restore-A-variable.patch text/x-patch 2.8 KB
v20240922-0019-transactional-variables.patch text/x-patch 39.2 KB
v20240922-0018-this-patch-changes-error-message-column-doesn-t-exis.patch text/x-patch 29.2 KB
v20240922-0016-plpgsql-implementation-for-LET-statement.patch text/x-patch 14.2 KB
v20240922-0014-allow-read-an-value-of-session-variable-directly-fro.patch text/x-patch 13.3 KB
v20240922-0015-allow-parallel-execution-queries-with-session-variab.patch text/x-patch 11.9 KB
v20240922-0013-Implementation-of-NOT-NULL-and-IMMUTABLE-clauses.patch text/x-patch 35.6 KB
v20240922-0012-Implementation-of-DEFAULT-clause-default-expressions.patch text/x-patch 33.6 KB
v20240922-0011-Implementation-ON-TRANSACTION-END-RESET-clause.patch text/x-patch 14.6 KB
v20240922-0010-implementation-of-temporary-session-variables.patch text/x-patch 39.3 KB
v20240922-0008-EXPLAIN-LET-support.patch text/x-patch 8.3 KB
v20240922-0007-GUC-session_variables_ambiguity_warning.patch text/x-patch 13.9 KB
v20240922-0006-plpgsql-tests.patch text/x-patch 16.9 KB
v20240922-0009-PREPARE-LET-support.patch text/x-patch 7.4 KB
v20240922-0004-DISCARD-VARIABLES.patch text/x-patch 9.6 KB
v20240922-0003-function-pg_session_variables-for-cleaning-tests.patch text/x-patch 4.6 KB
v20240922-0005-memory-cleaning-after-DROP-VARIABLE.patch text/x-patch 22.4 KB
v20240922-0001-Enhancing-catalog-for-support-session-variables-and-.patch text/x-patch 132.2 KB
v20240922-0002-Storage-for-session-variables-and-SQL-interface.patch text/x-patch 147.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ants Aasma 2024-09-22 08:50:31 Re: scalability bottlenecks with (many) partitions (and more)
Previous Message David Rowley 2024-09-22 05:56:59 Re: Using per-transaction memory contexts for storing decoded tuples

Browse pgsql-performance by date

  From Date Subject
Next Message Andrey Stikheev 2024-10-05 09:23:56 Performance degradation in Index searches with special characters
Previous Message Pavel Stehule 2024-09-18 06:21:44 Re: proposal: schema variables