> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]