Re: figuring out if there was a transaction in this connection already

Поиск
Список
Период
Сортировка
От Kundham Saare
Тема Re: figuring out if there was a transaction in this connection already
Дата
Msg-id 20040925154418.21856.qmail@web51705.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: figuring out if there was a transaction in this connection already  (Michael Fuhr <mike@fuhr.org>)
Ответы Re: figuring out if there was a transaction in this connection already
Список pgsql-general
> Checking currval() also wouldn't tell you whether
> any rows in a
> table had been updated.

I only need to know if there a row has been inserted.
I am trying to extend dbmirror so that I can easily
replicate all the transaction from a query even if
there it contains multiple update statements within
it.

Currently, this will insert multiple rows into a
pending table with different ID's.

Alternatively, is there some way to figure out what
the pid of the current connection is from the C
trigger function?

Best wishes,

M



__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail

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

Предыдущее
От: Együd Csaba
Дата:
Сообщение: Modifying users password in pg_shadow from php
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: Modifying users password in pg_shadow from php