Has this been fixed? ---------------------------------------------------------------------------
Hans-J?rgen Sch?nig wrote: > we have found a bug in CVS head using PL/Perl: > > [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
