Horton

Re: Fwd: Re: proposal: schema variables

Marcos Pegoraro <marcos@f10.com.br>

View thread
From: Marcos Pegoraro <marcos@f10.com.br>
To: Bruce Momjian <bruce@momjian.us>
Cc: Pavel Stehule <pavel.stehule@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-01-17T21:30:40Z
Lists: pgsql-hackers, pgsql-performance

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Move WAL sequence code into its own file

  2. Add ExplainState argument to pg_plan_query() and planner().

  3. Don't include access/htup_details.h in executor/tuptable.h

  4. Refactor to avoid code duplication in transformPLAssignStmt.

  5. Avoid including commands/dbcommands.h in so many places

  6. Restrict psql meta-commands in plain-text dumps.

  7. Split func.sgml into more manageable pieces

  8. Fix squashing algorithm for query texts

  9. EXPLAIN: Always use two fractional digits for row counts.

  10. Preliminary refactoring of plpgsql expression construction.

  11. plpgsql: pure parser and reentrant scanner

  12. Add some sanity checks in executor for query ID reporting

  13. Fix misleading error message context

  14. Add macros for looping through a List without a ListCell.

>
> > pá 17. 1. 2025 v 16:35 odesílatel Bruce Momjian <bruce@momjian.us>
> napsal:
>
> Okay, good summary.  Now, can people give feedback that they would want
> this committed to PostgreSQL?
>

I would love to have this functionality as soon as possible.
I already mentioned to Pavel that he did something very big, and
consequently difficult for anyone to commit, because these patches change a
lot of things in a lot of places.
Of course we want as much as possible, but who knows if a first, leaner
version was committed, with just session variables, so nothing related to
schemas, catalogs, grants,  dumps, etc, just a variable in memory, only
that. It would be really cool, and certainly easier for a committer to
agree with the code. And if the first commit occurs, others can follow.

Remember that some people don't use PSQL, so they don't have \set
Even \set variables are not typed, so CREATE VARIABLE T AS
DOMAIN_NUMBER_BETWEEN_1_AND_5 is really cool.

regards
Marcos