Re: Get current trasanction id

Поиск
Список
Период
Сортировка
От Marek Lewczuk
Тема Re: Get current trasanction id
Дата
Msg-id 41D06889.9040503@lewczuk.com
обсуждение исходный текст
Ответ на Re: Get current trasanction id  (Michael Fuhr <mike@fuhr.org>)
Ответы Re: Get current trasanction id
Список pgsql-general
Michael Fuhr napisał(a):
> On Mon, Dec 27, 2004 at 09:52:57AM +0100, Marek Lewczuk wrote:
>
>
>>is there any way to get current transaction id using plpgsql or sql ?
>
>
> A couple of people have posted suggestions but I'll ask a question:
>
> Why do you want the transaction ID?  What problem are you trying
> to solve?
>
Michael,
I've already solved the problem - I found somewhere on the web a very
simple C function, which returns transaction id. I need transaction id
for plperl functions setVar, getVar (using $_SHARED array). Functions
can write/read variables which are available either for connection or
transaction.

Regards,

ML



В списке pgsql-general по дате отправления:

Предыдущее
От: John DeSoi
Дата:
Сообщение: Re: error : syntax error at or near $1 for over select rows
Следующее
От: Eric Brown
Дата:
Сообщение: Long-running performance (MVCC, Vacuum, etc.) - Any fix?