From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Hans-Jürgen Schönig <postgres(at)cybertec(dot)at> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: bug: core dump in pl/perl (cvs head). |
Date: | 2005-07-30 02:46:35 |
Message-ID: | 200507300246.j6U2kZ300256@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Has this been fixed?
---------------------------------------------------------------------------
Hans-Jrgen Schnig wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2005-07-30 03:04:19 | Re: Sun inline assembler ... |
Previous Message | Bruce Momjian | 2005-07-30 02:13:33 | Re: BUG #1751: pg_restore bug |