| From: | Marek Lewczuk <newsy(at)lewczuk(dot)com> |
|---|---|
| To: | Steve - DND <postgres(at)digitalnothing(dot)com> |
| Cc: | postgres-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: [SPAM] Current transaction ID? |
| Date: | 2005-06-15 05:59:49 |
| Message-ID: | 42AFC3D5.5010702@lewczuk.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Steve - DND napisał(a):
> Simple question I'm sure, but how can I get the transaction ID that a query
> is currently running in? I can find all kinds of documentation talking about
> transaction ids, but nothing about how to get the current one.
>
You can compile attached function - this will return current transaction id.
| Attachment | Content-Type | Size |
|---|---|---|
| getcurrenttransactionid.c | text/plain | 192 bytes |
| getcurrenttransactionid.sql.in | text/plain | 170 bytes |
| Makefile | text/plain | 505 bytes |
| README.getcurrenttransactionid | text/plain | 7 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2005-06-15 06:08:02 | Re: Database became very slow(Help PLS) |
| Previous Message | Qingqing Zhou | 2005-06-15 05:41:52 | Re: Autovacuum in the backend |