Teodor Sigaev wrote:
> 2)
> # insert into a values(1);
You're running in auto-commit, mode. An implicit commit happens after
this statement. Which clears the table.
> # begin;
> # insert into a values(2);
> # rollback;
> # select * from a;
> a
> ---
> (0 rows)
>
> It seems to me that 1) is good, but 2) makes some strange, unpredictable
> result...
Looks right to me.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com