The following bug has been logged online:

Bug reference:      2507
Logged by:          N. Ramirez
Email address:      [EMAIL PROTECTED]
PostgreSQL version: 8.1.4
Operating system:   Linux Suse 9
Description:        Problem using two-phase commit
Details: 

I do not have an operation as it must be when use the functions to do
2-phase commit 

Example create table prueba (a int, b int);  
begin;  
PREPARE TRANSACTION 'aaaa';  
insert into prueba values (1,2);  
ROLLBACK PREPARED 'aaaa';  select * from prueba    
a               b  
-----------------------------  
1               2    
because?  
it did not do rollback?  
as it is used the method of 2-phase commit?  
idem for use of dblink

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to