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