Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group