From: | Radosław Smogura <rsmogura(at)softperience(dot)eu> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: Postgresql prepared transactions |
Date: | 2011-02-19 11:33:21 |
Message-ID: | 201102191233.21299.rsmogura@softperience.eu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)softperience(dot)eu> Saturday 19 February 2011 01:02:36
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> Saturday 19 February 2011 00:48:00
>
> > =?utf-8?q?Rados=C5=82aw_Smogura?= <rsmogura(at)softperience(dot)eu> 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
From | Date | Subject | |
---|---|---|---|
Next Message | PANAGIOTIS GERMANIS | 2011-02-19 11:46:10 | Mac OSX 10.6 libpq.5.dylib |
Previous Message | PANAGIOTIS GERMANIS | 2011-02-19 11:09:11 | Mac OSX 10.6 libpq.5.dylib |