Thought I would post here since the ruby dbi mailing list looks completely
dead.
There seems to be a bug in the postgres driver where the AutoCommit
attribute in the connect statement is ignored. Am I missing something here
or should I file a bug report on rubyforge?
require 'dbi'
dbh = DBI.connect("dbi:Pg:dbname=testdb;host=db.test.net<http://db.test.net>",
"testuser", "XXXXXXXX", 'AutoCommit' => false)
## This insert gets committed
comm = dbh.prepare("INSERT INTO test(x,y) VALUES('one','two')")
comm.execute
## This insert does not get committed
dbh['AutoCommit'] = false
comm = dbh.prepare("INSERT INTO test(x,y) VALUES('one','two')")
comm.execute