On Thu, 2002-10-17 at 09:06, Michael Schuerig wrote:
> Jim Weirich wrote:
> 
> > #!/usr/bin/env ruby
> > 
> > require 'dbi'
> > 
> > db = DBI.connect("DBI:Pg:junk", "jim")
> > 
> > fail "Usage: insert.rb first last" if ARGV.size != 2
> > first, last = ARGV
> > 
> > begin
> >   db['AutoCommit'] = false
> 
> Here's where it fails with
> 
> /usr/local/lib/site_ruby/1.6/DBD/Pg/Pg.rb:253:in `exec': ERROR:  
> 'autocommit' is not a valid option name (PGError)

Try the previous version (0.0.16) of Ruby/DBI until this has been 
fixed. Ruby/DBI 0.0.17 differs in the way it handles transactions; it
uses the PostgreSQL command "SET AUTOCOMMIT TO ON|OFF". But this does
not work as expected and is going to be removed from PostgreSQL.

Regards,

  Michael