Date: Fri, 17 Jan 2025 18:47:52 +0100
From: Dmitry Dolgov <9erthalion6@gmail.com>
To: Bruce Momjian <bruce@momjian.us>
Cc: Pavel Stehule <pavel.stehule@gmail.com>,
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: Fwd: Re: proposal: schema variables
Message-ID: <l254xqf2rvnpa7znemlajchutp7zc56czus34onsmutblylaum@7u652q7bxjye>
References: <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>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <Z4p-5R34LHYGO90V@momjian.us>
Archived-At: 
 <https://www.postgresql.org/message-id/l254xqf2rvnpa7znemlajchutp7zc56czus34onsmutblylaum%407u652q7bxjye>
Precedence: bulk

> On Fri, Jan 17, 2025 at 11:01:41AM GMT, Bruce Momjian wrote:
> On Fri, Jan 17, 2025 at 04:55:07PM +0100, Pavel Stehule wrote:
> > pá 17. 1. 2025 v 16:35 odesílatel Bruce Momjian <bruce@momjian.us> napsal:
> >
> >     So this feature would be like global GUC variables, with permission
> >     control?
> >
> > + types and domain type check - holds data in binary form - there are not
> > conversions binary, text
> > + it is declared - so less space for misuse is there. Custom GUC are absolutely
> > tolerant
> > + it is a fully database object, only owner can alter it,  and event triggers
> > are supported, sinval
> > + possibility to set mutability, default value
>
> Okay, good summary.  Now, can people give feedback that they would want
> this committed to PostgreSQL?

+1 into the bucket "want committed" from me as well. Throughout the
review process I've stumbled upon a few cases in my own projects, where
it would be useful.