Re: Postgresql prepared transactions

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