Re: execution id - Mailing list pgsql-sql

From David G. Johnston
Subject Re: execution id
Date
Msg-id CAKFQuwbcwbkObU_3HgX2YpFUBUUKWkJ3cG+g=OR=xA7hcb60bw@mail.gmail.com
Whole thread Raw
In response to execution id  ("Voillequin, Jean-Marc" <Jean-Marc.Voillequin@moodys.com>)
Responses RE: execution id  ("Voillequin, Jean-Marc" <Jean-Marc.Voillequin@moodys.com>)
List pgsql-sql
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.

pgsql-sql by date:

Previous
From: "Voillequin, Jean-Marc"
Date:
Subject: execution id
Next
From: "Voillequin, Jean-Marc"
Date:
Subject: RE: execution id