bug: core dump in pl/perl (cvs head).

From: Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>
To: pgsql-bugs(at)postgresql(dot)org
Subject: bug: core dump in pl/perl (cvs head).
Date: 2005-07-05 19:54:52
Message-ID: 42CAE58C.1030804@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

we have found a bug in CVS head using PL/Perl:

[hs(at)hp hs]$ psql test < /tmp/core.sql
DROP FUNCTION
CREATE FUNCTION
NOTICE: sql: SELECT 10, 10 FROM pg_locks WHERE transaction IS NOT NULL
AND pid = pg_backend_pid()
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost

DROP FUNCTION func();
CREATE OR REPLACE FUNCTION func() RETURNS int4 AS '
$sql = "SELECT 10, 10 FROM pg_locks "
. "WHERE transaction IS NOT NULL AND pid =
pg_backend_pid() ";
elog(NOTICE, "sql: $sql");
my $rv = spi_exec_query($sql);
return 0;
' LANGUAGE 'plperlu';

SELECT func();

somehow Perl does not seem to like the SPI.
only the development code seems to be affected.

thanks a lot,

hans

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Fuhr 2005-07-05 20:03:26 Re: Error installing Postgres on Solaris 9
Previous Message Tom Lane 2005-07-05 19:54:32 Re: Error installing Postgres on Solaris 9