From owner-freebsd-ruby@FreeBSD.ORG  Fri Nov 20 15:17:03 2009
Return-Path: <owner-freebsd-ruby@FreeBSD.ORG>
Delivered-To: freebsd-ruby@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id 24CDE1065676
	for <freebsd-ruby@freebsd.org>; Fri, 20 Nov 2009 15:17:03 +0000 (UTC)
	(envelope-from penty@dgc.se)
Received: from smtp05.dgcsystems.net (smtp05.dgcsystems.net [83.241.254.75])
	by mx1.freebsd.org (Postfix) with ESMTP id D6D718FC1D
	for <freebsd-ruby@freebsd.org>; Fri, 20 Nov 2009 15:17:02 +0000 (UTC)
Received: from picard.dgc.se (220.248.181.62.in-addr.dgcsystems.net
	[62.181.248.220])
	by smtp05.dgcsystems.net (Postfix) with ESMTP id 5212A1CC6E;
	Fri, 20 Nov 2009 16:43:20 +0100 (CET)
Received: by picard.dgc.se (Postfix, from userid 1000)
	id B68E0B833; Fri, 20 Nov 2009 16:17:00 +0100 (CET)
Date: Fri, 20 Nov 2009 16:17:00 +0100
From: Penty Wenngren <penty.wenngren@dgc.se>
To: Dirk Meyer <dirk.meyer@dinoex.sub.org>
Message-ID: <20091120151700.GY74360@picard.dgc.se>
References: <iLQ6Bi/njm@dmeyer.dinoex.sub.org>
	<20091111160649.GL74360@picard.dgc.se>
	<iLQ6Bi/njm@dmeyer.dinoex.sub.org>
	<20091116150907.GY74360@picard.dgc.se>
	<iTkUNi/njm@dmeyer.dinoex.sub.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
In-Reply-To: <iTkUNi/njm@dmeyer.dinoex.sub.org>
User-Agent: Mutt/1.4.2.3i
Organization: DGC Solutions AB
Cc: "freebsd-ruby@freebsd.org" <freebsd-ruby@freebsd.org>
Subject: Re: Ruby, dbi and PostgreSQL
X-BeenThere: freebsd-ruby@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
Reply-To: penty.wenngren@dgc.se
List-Id: FreeBSD-specific Ruby discussions <freebsd-ruby.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ruby>,
	<mailto:freebsd-ruby-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-ruby>
List-Post: <mailto:freebsd-ruby@freebsd.org>
List-Help: <mailto:freebsd-ruby-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-ruby>,
	<mailto:freebsd-ruby-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 20 Nov 2009 15:17:03 -0000

On Tue, Nov 17, 2009 at 06:12:41PM +0100, Dirk Meyer wrote:
> Penty Wenngren schrieb:,
> 
> > 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
> 
> There is an API breakage in the underlying postgres module.
> 
> Please install:
> 	ruby18-dbd_pg-0.3.8_2
> 	ruby18-pg-0.8.0
> 
> I verified it works here with just:
> require 'dbi'
> dbh = DBI.connect("DBI:Pg:mydb","user","secret")
> 

It took some time for ports to get updated, but after having upgraded to
the latest versions it seems to work just fine now. Thank you very much :)

// Penty

-- 

Penty Wenngren
DGC Solutions AB