MIME-Version: 1.0
References: <afb4e296d7ce57986f23bcfdee39b259b8f85f56.camel@cybertec.at>
 <CAFj8pRAjU-X6rEE9=1++PdtXOPc2uo=yu-tcFXByi-kN3B_7Vw@mail.gmail.com>
 <CAFj8pRC+hPCc2X88xC=pTJoqmVPApDsageZOMyqaxi5788WxHA@mail.gmail.com>
 <CAFj8pRDJ9cq00VYSHxs6LsoHNWjhYXyWWBtV6UgeWwhs0AHa9A@mail.gmail.com>
 <CAFj8pRBPXTcw_3fpKtgVthV2+9rZGhxitZ40DnAwCrK601TZZg@mail.gmail.com>
 <ndtfl4tsnpkb7m7hwvnmlpsascpgd3a7xvjmjhtxffsbrgygtm@4du6zsmnnwq5>
 <CAFj8pRAu4XvNCGu1751t=2YEqLqTjDA3FavMExm2S0KYQq=DdQ@mail.gmail.com>
 <CAFj8pRAsEoeZv0HEnA8CKgFKDSQ-wYw18Os1vdksWCV7ez2bVw@mail.gmail.com>
 <3chredgnjcmccym2kczawfih226b4ac6co7p6z4jeofevrcosi@mrsxkx2x2c65>
 <CAFj8pRBoWPDTOwn5FmMzc+1qiopw+N04U26nviOdF61fs8A2wQ@mail.gmail.com>
 <stckyvkl4yyzvgjsaawojs3xikke7mmds5bhv7l7qerclywywk@h4v4n43xm6u2>
 <CAFj8pRB_E1GM_YGT-ti4bXka6mhLdAAFeTe+BHgHFYC+qb-76g@mail.gmail.com>
In-Reply-To: 
 <CAFj8pRB_E1GM_YGT-ti4bXka6mhLdAAFeTe+BHgHFYC+qb-76g@mail.gmail.com>
From: Marcos Pegoraro <marcos@f10.com.br>
Date: Wed, 20 Nov 2024 10:29:10 -0300
Message-ID: 
 <CAB-JLwZfrsXZVOVVANieoPixKVRc_4HORVbkCPoSOLJe4DNXLw@mail.gmail.com>
Subject: Re: proposal: schema variables
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: Dmitry Dolgov <9erthalion6@gmail.com>,
 Laurenz Albe <laurenz.albe@cybertec.at>,
	Erik Rijkers <er@xs4all.nl>, Michael Paquier <michael@paquier.xyz>,
	Amit Kapila <amit.kapila16@gmail.com>, DUVAL REMI <REMI.DUVAL@cheops.fr>,
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000d951c50627582400"
Archived-At: 
 <https://www.postgresql.org/message-id/CAB-JLwZfrsXZVOVVANieoPixKVRc_4HORVbkCPoSOLJe4DNXLw%40mail.gmail.com>
Precedence: bulk

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

Em ter., 19 de nov. de 2024 =C3=A0s 16:15, Pavel Stehule <pavel.stehule@gma=
il.com>
escreveu:

> I wrote POC of VARIABLE(varname) syntax support
>

Not related with POC of VARIABLE but seeing your patches ...

Wouldn't it be better to use just one syntax and message for what to do ON
COMMIT ?

When creating a new variable you use
CREATE VARIABLE ... ON COMMIT DROP | ON TRANSACTION END RESET

On PSQL \dV+ you show
Transactional end action

Maybe all them could be just ON COMMIT
CREATE VARIABLE ... [ON COMMIT {NO ACTION, DROP, RESET}] and \dV+ just "on
commit" on title column

regards
Marcos

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

<div dir=3D"ltr"><div dir=3D"ltr">Em ter., 19 de nov. de 2024 =C3=A0s 16:15=
, Pavel Stehule &lt;<a href=3D"mailto:pavel.stehule@gmail.com">pavel.stehul=
e@gmail.com</a>&gt; escreveu:</div><div class=3D"gmail_quote"><blockquote c=
lass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px soli=
d rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div>I wrote POC of V=
ARIABLE(varname) syntax support<br></div></div></blockquote><div><br></div>=
<div><div class=3D"gmail_default" style=3D"font-family:verdana,sans-serif;c=
olor:rgb(102,102,102)">Not related with POC of VARIABLE but seeing your pat=
ches ...</div><br></div><div class=3D"gmail_default" style=3D"font-family:v=
erdana,sans-serif;color:rgb(102,102,102)">Wouldn&#39;t it be better to use =
just one syntax=C2=A0and message for what to do ON COMMIT ?</div><div><div =
class=3D"gmail_default" style=3D"font-family:verdana,sans-serif;color:rgb(1=
02,102,102)"><br></div><div class=3D"gmail_default" style=3D"font-family:ve=
rdana,sans-serif;color:rgb(102,102,102)">When creating a new variable you u=
se=C2=A0</div><div class=3D"gmail_default" style=3D"font-family:verdana,san=
s-serif;color:rgb(102,102,102)">CREATE VARIABLE ... ON COMMIT DROP | ON TRA=
NSACTION END RESET</div><div class=3D"gmail_default" style=3D"font-family:v=
erdana,sans-serif;color:rgb(102,102,102)"><br></div><div class=3D"gmail_def=
ault" style=3D"font-family:verdana,sans-serif;color:rgb(102,102,102)"><div =
class=3D"gmail_default">On PSQL=C2=A0\dV+ you show=C2=A0</div><div class=3D=
"gmail_default">Transactional end action</div><div class=3D"gmail_default">=
<br></div></div><div class=3D"gmail_default" style=3D"font-family:verdana,s=
ans-serif;color:rgb(102,102,102)">Maybe all them could be just ON COMMIT</d=
iv><div class=3D"gmail_default" style=3D"font-family:verdana,sans-serif;col=
or:rgb(102,102,102)">CREATE VARIABLE ... [ON COMMIT {NO ACTION, DROP, RESET=
}] and \dV+ just &quot;on commit&quot; on title column</div></div><div clas=
s=3D"gmail_default" style=3D"font-family:verdana,sans-serif;color:rgb(102,1=
02,102)"><br></div><div class=3D"gmail_default" style=3D"font-family:verdan=
a,sans-serif;color:rgb(102,102,102)">regards</div><div class=3D"gmail_defau=
lt" style=3D"font-family:verdana,sans-serif;color:rgb(102,102,102)">Marcos<=
/div></div></div>

--000000000000d951c50627582400--