Re: execution id

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: execution id
Дата
Msg-id CAKFQuwbcwbkObU_3HgX2YpFUBUUKWkJ3cG+g=OR=xA7hcb60bw@mail.gmail.com
обсуждение исходный текст
Ответ на execution id  ("Voillequin, Jean-Marc" <Jean-Marc.Voillequin@moodys.com>)
Ответы RE: execution id  ("Voillequin, Jean-Marc" <Jean-Marc.Voillequin@moodys.com>)
Список 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 по дате отправления:

Предыдущее
От: "Voillequin, Jean-Marc"
Дата:
Сообщение: execution id
Следующее
От: "Voillequin, Jean-Marc"
Дата:
Сообщение: RE: execution id