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

From: Kundham Saare <oxb1001001001(at)yahoo(dot)com>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: figuring out if there was a transaction in this connection already
Date: 2004-09-25 15:44:18
Message-ID: 20040925154418.21856.qmail@web51705.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2004-09-25 15:56:27 Re: Modifying users password in pg_shadow from php
Previous Message Együd Csaba 2004-09-25 15:40:27 Modifying users password in pg_shadow from php