Search Postgresql Archives

Re: Postgresql prepared transactions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

In any way may I ask to add information in protocol-message-formats.html that 
for command status for queries like COMMIT, ROLLBACK, PREPARE TRANSACTION 
status may be ROLLBACK. It is important for XA resources to check what 
actually happend. I can't find this in documentation as well.

Radek,

RadosÅaw Smogura <rsmogura@xxxxxxxxxxxxxxx> Saturday 19 February 2011 01:02:36
> Tom Lane <tgl@xxxxxxxxxxxxx> Saturday 19 February 2011 00:48:00
> 
> > =?utf-8?q?Rados=C5=82aw_Smogura?= <rsmogura@xxxxxxxxxxxxxxx> writes:
> > > I do following commands
> > > 
> > > test=# BEGIN;
> > > BEGIN
> > > test=# insert into testxa1 values(1);
> > > INSERT 0 1
> > > test=# insert ddddduuuuuppppp;
> > > ERROR:  syntax error at or near "ddddduuuuuppppp"
> > > LINE 1: insert ddddduuuuuppppp;
> > > 
> > >                ^
> > > 
> > > test=# PREPARE TRANSACTION 'a';
> > > ROLLBACK
> > > 
> > > Why on prepare transaction I got rollback.
> > 
> > Because the transaction had already failed due to the error.  This is
> > the same as if you'd done a plain COMMIT at that point.
> > 
> > 			regards, tom lane
> 
> Sorry, my wrong. I thought I can commit or rollback. In any way next bug
> JDBC.
> 
> Regards

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux