From: Scott Cain <cain@cshl.edu>
To: pgsql-interfaces@postgresql.org
Subject: DBD::PgSPI killing server connection
Date: Mon, 18 Jul 2005 13:06:26 -0400
Message-ID: <1121706386.4205.9.camel@localhost.localdomain> (raw)
Hello,
I am trying to write a plperlu function that uses DBD::PgSPI with Pg
version 7.4.8 (obtained via RPM from the Fedora Core 3 project). When I
install plperlu via 'createlang plperlu dbname' and then create this
function:
CREATE OR REPLACE FUNCTION perl_test() RETURNS void AS '
use DBI;
my $dbh = DBI->connect("dbi:PgSPI:internal", "", "");
my $sth = $dbh->prepare("select * from cvterm where name = ''gene''");
$sth->execute;
while (my @array = $sth->fetchrow_array) {
print "@array\n";
}
' LANGUAGE plperlu;
I then get this output when trying 'select perl_test();'
yeast=# select perl_test();
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.
I'm guessing there is something fundamental about DBD::PgSPI that I am
not getting; any idea what that is?
Thanks much,
Scott
--
------------------------------------------------------------------------
Scott Cain, Ph. D. cain@cshl.edu
GMOD Coordinator (http://www.gmod.org/) 216-392-3087
Cold Spring Harbor Laboratory
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: cain@cshl.edu
Subject: Re: DBD::PgSPI killing server connection
In-Reply-To: <1121706386.4205.9.camel@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox