So I was finally able to get a compiled binary for the code in this thread(thanks Magnus): http://archives.postgresql.org/pgsql-general/2005-06/msg00709.php So everything seemed to be fine with my GetCurrentTransactionID() function call returning the txn ID for each query I would run(as far as I could tell). Then I tried running a txn with multiple queries, and instead of just having one txn ID, each query had it's own. Does that make any sense? I was under the impression that a regular transaction block would have one txn ID assigned to it for its duration. Here's the query I ran: BEGIN; UPDATE partners SET partner_name = 'partner #5', activity_status_id = 1 WHERE partner_id = 5; UPDATE partners SET partner_name = 'partner #7' WHERE partner_id = 3; COMMIT; Should that have had the same txn ID for both of those? The GetCurrentTransactionID call occurs in a trigger, would that have an impact on the ID? Thanks, Steve ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
