Re: Postgresql prepared transactions

=?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