Le 17/01/2025 à 19:01, Bruce Momjian a écrit :
On Fri, Jan 17, 2025 at 04:55:07PM +0100, Pavel Stehule wrote:
pá 17. 1. 2025 v 16:35 odesílatel Bruce Momjian <br...@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?
For me, this is a must have. Not only because of the huge amount of time
that we will save in migration to PostgreSQL (i know that this is not an
argument) but because the only way we have to emulate such feature is to
use custom configuration directives or a PL language that allows global
variable. I have question almost every week on how to do that and the
only answer I have is do this ugly pl/pgsql coding. It will be nice to
have a feature to do that. Thanks Pavel and all involved in this
implementation.
--
Gilles Darold
http://www.darold.net/
