Re: Schema variables - new implementation for Postgres 15

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Julien Rouhaud <rjuju123(at)gmail(dot)com>
Cc: Erik Rijkers <er(at)xs4all(dot)nl>, Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>, Joel Jacobson <joel(at)compiler(dot)org>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Schema variables - new implementation for Postgres 15
Date: 2022-07-22 08:58:25
Message-ID: CAFj8pRCYLr5qQh3NyTERH+R--Gfo2tTkSWra-2h7sJ4exVbyPA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

čt 21. 7. 2022 v 9:34 odesílatel Julien Rouhaud <rjuju123(at)gmail(dot)com> napsal:

> Hi,
>
> On Thu, Jul 21, 2022 at 09:09:47AM +0200, Erik Rijkers wrote:
> > On 7/21/22 08:16, Pavel Stehule wrote:
> > > Hi
> > >
> > > new update of session variable;s implementation
> > >
> > > - fresh rebase
> > > - new possibility to trace execution with DEBUG1 notification
> > > - new SRF function pg_debug_show_used_session_variables that returns
> > > content of sessionvars hashtab
> > > - redesign of work with list of variables for reset, recheck, on commit
> > > drop, on commit reset
>
> Thanks for working on those! I will keep reviewing the patchset.
>
> > I don't know exactly what failed but the docs (html/pdf) don't build:
> >
> > cd ~/pg_stuff/pg_sandbox/pgsql.schema_variables/doc/src/sgml
> >
> > $ make html
> > /usr/bin/xmllint --path . --noout --valid postgres.sgml
> > postgres.sgml:374: element link: validity error : IDREF attribute linkend
> > references an unknown ID "catalog-pg-variable"
> > make: *** [Makefile:135: html-stamp] Error 4
>
> Apparently most of the changes in catalogs.sgml didn't survive the last
> rebase.
> I do see the needed section in v20220709-0012-documentation.patch:
>
> > + <sect1 id="catalog-pg-variable">
> > + <title><structname>pg_variable</structname></title>
> > [...]
>

should be fixed now

Thank you for check

Regards

Pavel

Attachment Content-Type Size
v20220722-0013-documentation.patch text/x-patch 42.4 KB
v20220722-0012-This-patch-changes-error-message-column-doesn-t-exis.patch text/x-patch 29.1 KB
v20220722-0009-Possibility-to-dump-session-variables-by-pg_dump.patch text/x-patch 19.4 KB
v20220722-0010-typedefs.patch text/x-patch 1.6 KB
v20220722-0011-Regress-tests-for-session-variables.patch text/x-patch 37.2 KB
v20220722-0008-Enhancing-psql-for-session-variables.patch text/x-patch 15.1 KB
v20220722-0007-DISCARD-VARIABLES-command.patch text/x-patch 3.2 KB
v20220722-0006-Support-of-LET-command-in-PLpgSQL.patch text/x-patch 11.5 KB
v20220722-0004-debug-func.patch text/x-patch 3.3 KB
v20220722-0005-LET-command.patch text/x-patch 38.1 KB
v20220722-0003-typecheck-check-of-consistency-of-format-of-stored-v.patch text/x-patch 28.0 KB
v20220722-0002-session-variables.patch text/x-patch 83.4 KB
v20220722-0001-Catalogue-support-for-session-variables.patch text/x-patch 95.3 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Yuya Watari 2022-07-22 09:16:51 Re: [PoC] Reducing planning time when tables have many partitions
Previous Message Amit Kapila 2022-07-22 08:56:02 Re: Collect ObjectAddress for ATTACH DETACH PARTITION to use in event trigger