1)
# create temp table a ( a int ) without oids on commit delete rows;
# insert into a values(1);
# begin;
# insert into a values(2);
# commit;
# select * from a; a
---
(0 rows)
2)
# insert into a values(1);
# 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...
--
Teodor Sigaev E-mail: teodor@sigaev.ru
WWW: http://www.sigaev.ru/