| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | "Voillequin, Jean-Marc" <Jean-Marc(dot)Voillequin(at)moodys(dot)com> |
| Cc: | "pgsql-sql(at)lists(dot)postgresql(dot)org" <pgsql-sql(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: execution id |
| Date: | 2022-08-30 16:26:51 |
| Message-ID: | CAKFQuwbcwbkObU_3HgX2YpFUBUUKWkJ3cG+g=OR=xA7hcb60bw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Tue, Aug 30, 2022 at 9:23 AM Voillequin, Jean-Marc <
Jean-Marc(dot)Voillequin(at)moodys(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Voillequin, Jean-Marc | 2022-08-30 16:32:29 | RE: execution id |
| Previous Message | Voillequin, Jean-Marc | 2022-08-30 16:22:45 | execution id |