From: | Scott Cain <cain(at)cshl(dot)edu> |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | DBD::PgSPI killing server connection |
Date: | 2005-07-18 17:06:26 |
Message-ID: | 1121706386.4205.9.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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(at)cshl(dot)edu
GMOD Coordinator (http://www.gmod.org/) 216-392-3087
Cold Spring Harbor Laboratory
From | Date | Subject | |
---|---|---|---|
Next Message | Zlatko Matić | 2005-07-24 12:09:31 | postgres temporary tables and MS Access |
Previous Message | Richard Jones | 2005-07-18 17:01:14 | Re: Parse a statement, get parameter types and return types |