Date: Mon, 16 Nov 2009 16:45:33 +0100 From: Penty Wenngren <penty.wenngren@dgc.se> To: Dirk Meyer <dirk.meyer@dinoex.sub.org> Cc: "freebsd-ruby@freebsd.org" <freebsd-ruby@freebsd.org> Subject: Re: Ruby, dbi and PostgreSQL Message-ID: <20091116154533.GZ74360@picard.dgc.se> In-Reply-To: <CRumTC/njm@dmeyer.dinoex.sub.org> References: <iLQ6Bi/njm@dmeyer.dinoex.sub.org> <20091111160649.GL74360@picard.dgc.se> <iLQ6Bi/njm@dmeyer.dinoex.sub.org> <20091116150907.GY74360@picard.dgc.se> <CRumTC/njm@dmeyer.dinoex.sub.org>
next in thread | previous in thread | raw e-mail | index | archive | help
On Mon, Nov 16, 2009 at 04:17:48PM +0100, Dirk Meyer wrote: > Hallo Penty Wenngren, > > > Thanks Dirk, it seems your patches solved that problem. However, now I get > > another error message instead: > > > > $ irb > > irb(main):001:0> require 'rubygems' > > => true > > irb(main):002:0> require 'dbi' > > => true > > irb(main):003:0> dbh = DBI.connect("DBI:Pg:mydb","user","secret") > > DBI::OperationalError: can't format > > from /usr/local/lib/ruby/site_ruby/1.8/dbd/pg/database.rb:82:in > > `initialize' > > from /usr/local/lib/ruby/site_ruby/1.8/dbd/Pg.rb:157:in `new' > > from /usr/local/lib/ruby/site_ruby/1.8/dbd/Pg.rb:157:in `connect' > > from /usr/local/lib/ruby/site_ruby/1.8/dbi/handles/driver.rb:33:in > > `connect' > > from /usr/local/lib/ruby/site_ruby/1.8/dbi.rb:148:in `connect' > > from (irb):3 > > The short name never worked for me even before the update. > Do you have a setup where it worked this way? > Yes, we actually have a whole bunch of scripts with the short name that worked until the upgrade last week. > I used for some years this form and I tested it: > dbh = DBI.connect("DBI:Pg:dbname=mydb","user","secret") > I will have that in mind. Better safe than sorry, so I will convert the connection strings in our scripts to use that form instead. I tried the same connection string as before, but with dbname=mydb instead, and I get the same error message. // Penty -- Penty Wenngren DGC Solutions AB
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20091116154533.GZ74360>