MIME-Version: 1.0
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>
In-Reply-To: <Z4p-5R34LHYGO90V@momjian.us>
From: Marcos Pegoraro <marcos@f10.com.br>
Date: Fri, 17 Jan 2025 18:54:17 -0300
Message-ID: 
 <CAB-JLwb5f-uta=N=dwx2NdrEy272RWjGNi996jEgjgtMyQQT6w@mail.gmail.com>
Subject: Re: Fwd: Re: proposal: schema variables
To: Bruce Momjian <bruce@momjian.us>
Cc: Pavel Stehule <pavel.stehule@gmail.com>,
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000067d85c062bedf65b"
Archived-At: 
 <https://www.postgresql.org/message-id/CAB-JLwb5f-uta%3DN%3Ddwx2NdrEy272RWjGNi996jEgjgtMyQQT6w%40mail.gmail.com>
Precedence: bulk

--00000000000067d85c062bedf65b
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Em sex., 17 de jan. de 2025 =C3=A0s 13:01, Bruce Momjian <bruce@momjian.us>
escreveu:

> 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

--00000000000067d85c062bedf65b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div>Em sex., 17 de jan. de 2025 =C3=A0s =
13:01, Bruce Momjian &lt;<a href=3D"mailto:bruce@momjian.us">bruce@momjian.=
us</a>&gt; escreveu:</div></div><div class=3D"gmail_quote gmail_quote_conta=
iner"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;b=
order-left:1px solid rgb(204,204,204);padding-left:1ex">
Okay, good summary.=C2=A0 Now, can people give feedback that they would wan=
t<br>
this committed to PostgreSQL?</blockquote><div><br></div><div class=3D"gmai=
l_default" style=3D"font-family:verdana,sans-serif;color:rgb(102,102,102)">=
I would love to have this functionality as soon as possible.=C2=A0</div><di=
v><font face=3D"verdana, sans-serif" color=3D"#666666">I already mentioned =
to Pavel that he did something very big, and consequently difficult for any=
one to commit, because=C2=A0<span class=3D"gmail_default"></span>t<span cla=
ss=3D"gmail_default">hese patches=C2=A0</span>change a lot of things in a l=
ot of places.<br>Of course we want as much as possible, but who knows if a =
first,<span class=3D"gmail_default"></span>=C2=A0leaner version was committ=
ed, with just session variables,=C2=A0<span class=3D"gmail_default">so noth=
ing related to schemas, catalogs, grants,=C2=A0 dumps, etc, just a variable=
 in memory, only that.=C2=A0</span></font><span class=3D"gmail_default" sty=
le=3D"color:rgb(102,102,102);font-family:verdana,sans-serif">I</span><span =
style=3D"color:rgb(102,102,102);font-family:verdana,sans-serif">t would be =
really cool, and certainly easier for a committer to agree with the code. A=
nd if the first commit occurs<span class=3D"gmail_default">, others can fol=
low.</span></span></div><div><span style=3D"color:rgb(102,102,102);font-fam=
ily:verdana,sans-serif"><span class=3D"gmail_default"><br></span></span></d=
iv><div><div class=3D"gmail_default" style=3D"font-family:verdana,sans-seri=
f;color:rgb(102,102,102)">Remember that some people don&#39;t use PSQL, so =
they don&#39;t have \set</div><div class=3D"gmail_default" style=3D"font-fa=
mily:verdana,sans-serif;color:rgb(102,102,102)">Even \set variables are not=
 typed, so CREATE VARIABLE T AS DOMAIN_NUMBER_BETWEEN_1_AND_5 is really coo=
l.</div></div><div><span style=3D"color:rgb(102,102,102);font-family:verdan=
a,sans-serif"><span class=3D"gmail_default"><br></span></span></div><div><s=
pan style=3D"color:rgb(102,102,102);font-family:verdana,sans-serif"><span c=
lass=3D"gmail_default">regards</span></span></div><font color=3D"#888888"><=
div><span style=3D"color:rgb(102,102,102);font-family:verdana,sans-serif"><=
span class=3D"gmail_default">Marcos</span></span></div></font></div></div>

--00000000000067d85c062bedf65b--