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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to