[HACKERS] PostgreSql - access modified rows in prepare transaction command

2013-02-20 Thread pierpaolo.cincilla
Hello, I have the problem to access modified data (updates and inserts) in a prepare transaction statement before a commit/rollback. For example consider the following block: BEGIN; do some update; do some insert; PREPARE TRANSACTION 'transaction1'; After executing the 'prepare' comma

[HACKERS] Re: PostgreSql - access modified rows in prepare transaction command

2013-02-20 Thread pierpaolo.cincilla
Thank you Heikki for your reply. As you suggest, I will explain better what I'm trying to accomplish. What I'm writing a ditributed two-phase-commit termination protocol that work in this manner: 1) Each site has a replica of the database. A site A perform a transaction t1 and prepare it (PREPAR