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

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

In response to

Responses

Browse pgsql-bugs by date

  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