MIME-Version: 1.0
References: 
 <MN2PR20MB27356F937609C465A9FD9B2EBE799@MN2PR20MB2735.namprd20.prod.outlook.com>
In-Reply-To: 
 <MN2PR20MB27356F937609C465A9FD9B2EBE799@MN2PR20MB2735.namprd20.prod.outlook.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Tue, 30 Aug 2022 09:26:51 -0700
Message-ID: 
 <CAKFQuwbcwbkObU_3HgX2YpFUBUUKWkJ3cG+g=OR=xA7hcb60bw@mail.gmail.com>
Subject: Re: execution id
To: "Voillequin, Jean-Marc" <Jean-Marc.Voillequin@moodys.com>
Cc: "pgsql-sql@lists.postgresql.org" <pgsql-sql@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000039b0505e777dab4"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwbcwbkObU_3HgX2YpFUBUUKWkJ3cG%2Bg%3DOR%3DxA7hcb60bw%40mail.gmail.com>
Precedence: bulk

--000000000000039b0505e777dab4
Content-Type: text/plain; charset="UTF-8"

On Tue, Aug 30, 2022 at 9:23 AM Voillequin, Jean-Marc <
Jean-Marc.Voillequin@moodys.com> wrote:

> Hello guys,
>
>
>
> Is there a kind of magical system administration function that returns a
> unique id each time a select/insert/update/delete statement is launched?
>
>
>

Not sure why you thought the "SQL" list was a good choice for this
question...but assuming you actually want something exposed to SQL the
answer would be no.  Internal state management (the "CommandCounter" as I
believe it is called) is an implementation artifact not exposed to the DBA.

David J.

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

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Tue, Aug 30, 2022 at 9:23 AM Voillequin, Jean-Marc &lt;=
<a href=3D"mailto:Jean-Marc.Voillequin@moodys.com">Jean-Marc.Voillequin@moo=
dys.com</a>&gt; wrote:</span><br></div></div><div class=3D"gmail_quote"><bl=
ockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-lef=
t:1px solid rgb(204,204,204);padding-left:1ex"><div class=3D"gmail-msg-3762=
157100602634915">


<div lang=3D"EN-US" style=3D"overflow-wrap: break-word;">
<div class=3D"gmail-m_-3762157100602634915WordSection1">
<p class=3D"MsoNormal">Hello guys,<u></u><u></u></p>
<p class=3D"MsoNormal"><u></u>=C2=A0<u></u></p>
<p class=3D"MsoNormal">Is there a kind of magical system administration fun=
ction that returns a unique id each time a select/insert/update/delete stat=
ement is launched?<u></u><u></u></p>
<p class=3D"MsoNormal"><u></u>=C2=A0</p></div></div></div></blockquote><div=
><br></div><div class=3D"gmail_default" style=3D"font-family:arial,helvetic=
a,sans-serif">Not sure why you thought the &quot;SQL&quot; list was a good =
choice for this question...but assuming you actually want something exposed=
 to SQL the answer would be no.=C2=A0 Internal state management (the &quot;=
CommandCounter&quot; as I believe it is called) is an implementation artifa=
ct not exposed to the DBA.</div><div class=3D"gmail_default" style=3D"font-=
family:arial,helvetica,sans-serif"><br></div><div class=3D"gmail_default" s=
tyle=3D"font-family:arial,helvetica,sans-serif">David J.</div><div class=3D=
"gmail_default" style=3D"font-family:arial,helvetica,sans-serif"></div></di=
v></div>

--000000000000039b0505e777dab4--