Re: Postgresql prepared transactions

Tom Lane <tgl@sss.pgh.pa.us> Saturday 19 February 2011 00:48:00
> =?utf-8?q?Rados=C5=82aw_Smogura?= <rsmogura@softperience.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