Subject: DBD::PgSPI killing server connection
From: Scott Cain <cain@cshl.edu>
To: pgsql-interfaces@postgresql.org
Content-Type: text/plain
Date: Mon, 18 Jul 2005 13:06:26 -0400
Message-Id: <1121706386.4205.9.camel@localhost.localdomain>
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit

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