Re: Schema variables - new implementation for Postgres 15
Pavel Stehule <pavel.stehule@gmail.com>
From: Pavel Stehule <pavel.stehule@gmail.com>
To: Dmitry Dolgov <9erthalion6@gmail.com>
Cc: Peter Eisentraut <peter.eisentraut@enterprisedb.com>, Sergey Shinderuk <s.shinderuk@postgrespro.ru>,
Tomas Vondra <tomas.vondra@enterprisedb.com>, Julien Rouhaud <rjuju123@gmail.com>, dean.a.rasheed@gmail.com, er@xs4all.nl, joel@compiler.org, pgsql-hackers@lists.postgresql.org
Date: 2024-02-20T19:29:29Z
Lists: pgsql-hackers
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Allow underscores in integer and numeric constants.
- faff8f8e47f1 16.0 cited
-
Remove special outfuncs/readfuncs handling of RangeVar.catalogname.
- 3cece34be842 16.0 cited
-
Remove extra space from dumped ALTER DEFAULT PRIVILEGES.
- 2af33369e794 16.0 cited
-
Create FKs properly when attaching table as partition
- b0284bfb1db5 16.0 cited
-
psql: improve tab-complete's handling of variant SQL names.
- 02b8048ba5dc 15.0 cited
Attachments
- v20240220-0016-GUC-session_variables_ambiguity_warning.patch (text/x-patch) patch v20240220-0016
- v20240220-0018-this-patch-changes-error-message-column-doesn-t-exis.patch (text/x-patch) patch v20240220-0018
- v20240220-0017-expression-with-session-variables-can-be-inlined.patch (text/x-patch) patch v20240220-0017
- v20240220-0014-allow-parallel-execution-queries-with-session-variab.patch (text/x-patch) patch v20240220-0014
- v20240220-0015-plpgsql-implementation-for-LET-statement.patch (text/x-patch) patch v20240220-0015
- v20240220-0013-allow-read-an-value-of-session-variable-directly-fro.patch (text/x-patch) patch v20240220-0013
- v20240220-0011-Implementation-of-DEFAULT-clause-default-expressions.patch (text/x-patch) patch v20240220-0011
- v20240220-0012-Implementation-of-NOT-NULL-and-IMMUTABLE-clauses.patch (text/x-patch) patch v20240220-0012
- v20240220-0009-implementation-of-temporary-session-variables.patch (text/x-patch) patch v20240220-0009
- v20240220-0010-Implementation-ON-TRANSACTION-END-RESET-clause.patch (text/x-patch) patch v20240220-0010
- v20240220-0008-plpgsql-tests.patch (text/x-patch) patch v20240220-0008
- v20240220-0007-PREPARE-LET-support.patch (text/x-patch) patch v20240220-0007
- v20240220-0006-EXPLAIN-LET-support.patch (text/x-patch) patch v20240220-0006
- v20240220-0005-memory-cleaning-after-DROP-VARIABLE.patch (text/x-patch) patch v20240220-0005
- v20240220-0004-DISCARD-VARIABLES.patch (text/x-patch) patch v20240220-0004
- v20240220-0003-function-pg_session_variables-for-cleaning-tests.patch (text/x-patch) patch v20240220-0003
- v20240220-0002-Storage-for-session-variables-and-SQL-interface.patch (text/x-patch) patch v20240220-0002
- v20240220-0019-transactional-variables.patch (text/x-patch) patch v20240220-0019
- v20240220-0001-Enhancing-catalog-for-support-session-variables-and-.patch (text/x-patch) patch v20240220-0001
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