=?utf-8?q?Rados=C5=82aw_Smogura?= <rsmogura@xxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general