Re: bug: core dump in pl/perl (cvs head).
От | Bruce Momjian |
---|---|
Тема | Re: bug: core dump in pl/perl (cvs head). |
Дата | |
Msg-id | 200507300246.j6U2kZ300256@candle.pha.pa.us обсуждение исходный текст |
Ответ на | bug: core dump in pl/perl (cvs head). (Hans-Jürgen Schönig <postgres@cybertec.at>) |
Ответы |
Re: bug: core dump in pl/perl (cvs head).
|
Список | pgsql-bugs |
Has this been fixed? --------------------------------------------------------------------------- Hans-Jürgen Schönig wrote: > we have found a bug in CVS head using PL/Perl: > > [hs@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@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
В списке pgsql-bugs по дате отправления: