From owner-freebsd-ruby@FreeBSD.ORG  Mon Nov 16 15:20:56 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 2610B1065679
	for <freebsd-ruby@freebsd.org>; Mon, 16 Nov 2009 15:20:56 +0000 (UTC)
	(envelope-from dirk.meyer@dinoex.sub.org)
Received: from uucp.dinoex.sub.de (uucp.dinoex.sub.de [194.45.71.2])
	by mx1.freebsd.org (Postfix) with ESMTP id 9DECE8FC12
	for <freebsd-ruby@freebsd.org>; Mon, 16 Nov 2009 15:20:55 +0000 (UTC)
Received: from uucp.dinoex.sub.de (uucp.dinoex.sub.de [194.45.71.2] (may be
	forged))
	by uucp.dinoex.sub.de (8.14.3/8.14.2) with ESMTP id nAGFK2bl019398;
	Mon, 16 Nov 2009 16:20:03 +0100 (CET)
	(envelope-from dirk.meyer@dinoex.sub.org)
Received: from build7.dinoex.sub.de (dinoex@localhost)
	by uucp.dinoex.sub.de (8.14.3/8.14.2/Submit) with BSMTP id
	nAGFK22Z019386; Mon, 16 Nov 2009 16:20:02 +0100 (CET)
	(envelope-from dirk.meyer@dinoex.sub.org)
To: penty.wenngren@dgc.se, freebsd-ruby@freebsd.org
Message-ID: <CRumTC/njm@dmeyer.dinoex.sub.org>
From: dirk.meyer@dinoex.sub.org (Dirk Meyer)
Organization: privat
Date: Mon, 16 Nov 2009 16:17:48 +0100
X-Mailer: Dinoex 1.79
References: <iLQ6Bi/njm@dmeyer.dinoex.sub.org>
	<20091111160649.GL74360@picard.dgc.se>
	<iLQ6Bi/njm@dmeyer.dinoex.sub.org>
	<20091116150907.GY74360@picard.dgc.se>
X-Gateway: ZCONNECT build7.dinoex.sub.de [UNIX/Connect 0.94]
X-PGP-Fingerprint: 44 16 EC 0A D3 3A 4F 28  8A 8A 47 93 F1 CF
	2F 12
X-Copyright: (C) Copyright 2001 by Dirk Meyer -- All rights reserved.
X-PGP-Key-Avail: mailto:pgp-public-keys@keys.de.pgp.net Subject:GET 0x331CDA5D
X-ZC-VIA: 20091116000000W+1@dinoex.sub.org
X-Milter: Spamilter (Reciever: uucp.dinoex.sub.de; Sender-ip: 194.45.71.2;
	Sender-helo: uucp.dinoex.sub.de; )
X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-4.2.2
	(uucp.dinoex.sub.de [194.45.71.2]);
	Mon, 16 Nov 2009 16:20:05 +0100 (CET)
Cc: 
Subject: Re: Ruby, dbi and PostgreSQL
X-BeenThere: freebsd-ruby@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
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: Mon, 16 Nov 2009 15:20:56 -0000

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?

I used for some years this form and I tested it:
dbh = DBI.connect("DBI:Pg:dbname=mydb","user","secret")

kind regards Dirk

- Dirk Meyer, Im Grund 4, 34317 Habichtswald, Germany
- [dirk.meyer@dinoex.sub.org],[dirk.meyer@guug.de],[dinoex@FreeBSD.org]
http://people.freebsd.org/~dinoex/errorlogs/