Transactions (basically) seem to work. No immediate side-effects to using transaction objects, or doing multiple queries in a given TX context.

Aurynn Shaw · Aurynn Shaw · commit df1f350448fa · 2010-10-27T23:06:08.000-07:00
Added a basic test-case as t/transaction.js
diff --git a/t/transaction.js b/t/transaction.js
@@ -0,0 +1,25 @@
+var sys = require("sys");
+var pg = require("../lib/postgres-pure");
+pg.DEBUG=0;
+
+var db = new pg.connect("pgsql://test:12345@localhost:5432/template1");
+db.transaction(function (tx) {
+    tx.begin();
+    tx.query("CREATE TABLE insert_test (id serial not null, val text)", function (err, rs) {
+        // Null query.
+    });
+    tx.query("INSERT INTO insert_test (val) VALUES (?) RETURNING id", "test value", function (err,rs) {
+        console.log(sys.inspect(rs));
+    });
+    tx.prepare("INSERT INTO insert_test (val) VALUES (?) RETURNING id", function (sth) {
+        sth.execute("twooooo", function (err, rs) {
+            console.log(sys.inspect(rs));
+        });
+    });
+    tx.rollback();
+    tx.query("SELECT * FROM insert_test", function (err, rs) {
+        // Should error
+        console.log(sys.inspect(err));
+    });
+});
+db.close();
