Re: figuring out if there was a transaction in this connection already - Mailing list pgsql-general

From Kundham Saare
Subject Re: figuring out if there was a transaction in this connection already
Date
Msg-id 20040925154418.21856.qmail@web51705.mail.yahoo.com
Whole thread Raw
In response to Re: figuring out if there was a transaction in this connection already  (Michael Fuhr <mike@fuhr.org>)
Responses Re: figuring out if there was a transaction in this connection already  (Michael Fuhr <mike@fuhr.org>)
List 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 by date:

Previous
From: Együd Csaba
Date:
Subject: Modifying users password in pg_shadow from php
Next
From: Michael Fuhr
Date:
Subject: Re: Modifying users password in pg_shadow from php