Message-ID: <42cf4ffed1779895cd80be940e638751d4847482.camel@cybertec.at>
Subject: Re: Fwd: Re: proposal: schema variables
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Bruce Momjian <bruce@momjian.us>, Pavel Stehule <pavel.stehule@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: Fri, 17 Jan 2025 17:43:13 +0100
In-Reply-To: <Z4p-5R34LHYGO90V@momjian.us>
References: 
	<CAFj8pRCwddC_o1FMyp_mMCyzzuvU7a0f+1X3tHRKmaFhK2K7jw@mail.gmail.com>
	 <Z4peH6wnmE9QdGYk@momjian.us>
	 <CAFj8pRDncxFC+CPy5xoun00uzAOaiyKAkvfby94LfqQuVa4EFA@mail.gmail.com>
	 <Z4pmKI2yodbDn5vw@momjian.us>
	 <CAFj8pRA8U8ARQ+2Y3kc7BUB-J3LzraQ4kn__Y5LK3mevY_xijQ@mail.gmail.com>
	 <Z4priK3Ppl7IKvW_@momjian.us>
	 <CAFj8pRDTGh2DzTkYaAg2EdTsezU-CRSCM-CsfvHvx6JAD1=xdQ@mail.gmail.com>
	 <CAFj8pRAki6SGw2Dw-73ubQoDY9yPvfUQBjqr_LN35T7YBcsxmQ@mail.gmail.com>
	 <Z4p41KpSENxS0ASL@momjian.us>
	 <CAFj8pRCJFQ0UQzZoJRdxv51Vst_emnXMbZtWNv0HTWzeZ0j9Eg@mail.gmail.com>
	 <Z4p-5R34LHYGO90V@momjian.us>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/42cf4ffed1779895cd80be940e638751d4847482.camel%40cybertec.at>
Precedence: bulk

On Fri, 2025-01-17 at 11:01 -0500, Bruce Momjian wrote:
> On Fri, Jan 17, 2025 at 04:55:07PM +0100, Pavel Stehule wrote:
> > p=C3=A1 17. 1. 2025 v=C2=A016:35 odes=C3=ADlatel Bruce Momjian <bruce@m=
omjian.us> napsal:
> >=20
> >     So this feature would be like global GUC variables, with permission
> >     control?
> >=20
> > + types and domain type check - holds data in binary form - there are n=
ot
> > conversions binary, text
> > + it is declared - so less space for misuse is there. Custom GUC are ab=
solutely
> > tolerant
> > + it is a fully database object, only owner can alter it,=C2=A0 and eve=
nt triggers
> > are supported, sinval
> > + possibility to set mutability, default value
>=20
> Okay, good summary.  Now, can people give feedback that they would want
> this committed to PostgreSQL?

I would like to see this committed too, or at least relevant parts of it.

It addresses the perennial problem of people putting state into placeholder
GUCs to pass information between the application and the database
(SET myapp.application_id =3D 'user_laurenz').

Also, it cann pass information between the code in DO statements and
the surrounding SQL code.

Yours,
Laurenz Albe