Message-ID: <55472.216.41.12.254.1150814612.squirrel@webmail.webopticon.org>
In-Reply-To: <44980423.7080109@3times25.net>
References: <4497F919.7050203@3times25.net>
	<20060620135945.GB25678@svana.org> <44980423.7080109@3times25.net>
Date: Tue, 20 Jun 2006 10:43:32 -0400 (EDT)
Subject: Re: help with error message from perl Pg
From: "A.M." <agentm@themactionfaction.com>
To: pgsql-general@postgresql.org
User-Agent: SquirrelMail/1.5.1 [CVS]
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit

On Tue, June 20, 2006 10:20 am, Geoffrey wrote:

>
> We considered that and have verified that we are not closing it.  But,
> the question came up, should we be passing it by reference or value?  We
> are doing the following:
>
> my $conn = Pg::connectdb ("dbname=$db port=$port"); .
> .
> my $retVal = &$prog($conn, @args);
>
> Question is, should we be doing:
>
>
> my $retVal = &$prog(\$conn, @args);
>
>
> FYI, there's no expectation of changing $conn in anyway within the sub
> routines.

You are using a completely outdated interface to postgres. Looking on
CPAN, Pg.pm was last updated 04 Apr 2000. Which version of postgresql are
you using? It is likely that the old interface blows up when connecting to
a postgresql from >2000.

-M