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