Horton

Re: Schema variables - new implementation for Postgres 15

Pavel Stehule <pavel.stehule@gmail.com>

View thread
From: Pavel Stehule <pavel.stehule@gmail.com>
To: Julien Rouhaud <rjuju123@gmail.com>
Cc: Erik Rijkers <er@xs4all.nl>, Dean Rasheed <dean.a.rasheed@gmail.com>, Joel Jacobson <joel@compiler.org>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2022-07-22T08:58:25Z
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 →

  1. Allow underscores in integer and numeric constants.

  2. Remove special outfuncs/readfuncs handling of RangeVar.catalogname.

  3. Remove extra space from dumped ALTER DEFAULT PRIVILEGES.

  4. Create FKs properly when attaching table as partition

  5. psql: improve tab-complete's handling of variant SQL names.

Attachments

čt 21. 7. 2022 v 9:34 odesílatel Julien Rouhaud <rjuju123@gmail.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