| 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: | Whole Thread | Raw Message | 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 |