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