public inbox for [email protected]
help / color / mirror / Atom feedFrom: Alexander Kukushkin <[email protected]>
To: Tom Lane <[email protected]>
Cc: PostgreSQL-development <[email protected]>
Subject: Re: Allow custom parameters with more than one dot in config files.
Date: Wed, 20 Dec 2023 11:29:24 +0100
Message-ID: <CAFh8B=nXUp-bJenhfLzQ8LooXVmcNNfC=0CMYoBr=izqhJ5rDg@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAFh8B==xZ_qJNPtyajD5FSZbLKKXiOKv9Hoj08vcUHeo1rcoqw@mail.gmail.com>
<[email protected]>
On Tue, 19 Dec 2023 at 16:13, Tom Lane <[email protected]> wrote:
>
> I wonder if we wouldn't be better advised to require exactly one dot.
> This isn't a feature that we really encourage users to use, and the
> further we move the goalposts for it, the harder it will be to replace
> it. In particular I doubt the long-stalled session-variables patch
> could support such names, since it needs the names to conform to
> normal SQL rules.
>
If I understand correctly, session variables don't even intersect with
custom parameters.
Also, they seems to work fine with FQDN:
postgres=# create database testdb;
CREATE DATABASE
postgres=# \c testdb
You are now connected to database "testdb" as user "akukushkin".
testdb=# create schema testschema;
CREATE SCHEMA
testdb=# create variable testdb.testschema.testvar int;
CREATE VARIABLE
testdb=# let testdb.testschema.testvar = 1;
LET
testdb=# select testdb.testschema.testvar;
testvar
---------
1
(1 row)
Regards,
--
Alexander Kukushkin
view thread (2+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Allow custom parameters with more than one dot in config files.
In-Reply-To: <CAFh8B=nXUp-bJenhfLzQ8LooXVmcNNfC=0CMYoBr=izqhJ5rDg@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox