Re: Get current trasanction id

Поиск
Список
Период
Сортировка
От Joachim Zobel
Тема Re: Get current trasanction id
Дата
Msg-id 1104246353.22419.216.camel@localhost
обсуждение исходный текст
Ответ на Re: Get current trasanction id  (Marek Lewczuk <newsy@lewczuk.com>)
Ответы Re: Get current trasanction id
Список pgsql-general
Am Mo, den 27.12.2004 schrieb Marek Lewczuk um 20:54:
> Michael Fuhr napisał(a):
> > Why do you want the transaction ID?  What problem are you trying
> > to solve?
> >
> 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.

It would be nice to have that in pgplsql. I once needed a transaction Id
in oracle for a historisation trigger. It saves before copies of the
modified records on a per transaction basis.

Sincerely,
Joachim

--

"... ein Geschlecht erfinderischer Zwerge, die fuer alles gemietet werden
koennen."                            - Bertolt Brecht - Leben des Galilei


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

Предыдущее
От: Vivek Khera
Дата:
Сообщение: Re: Long-running performance (MVCC, Vacuum, etc.) - Any fix?
Следующее
От: Pierre-Frédéric Caillaud
Дата:
Сообщение: Re: running a query file of 42MB