Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2005-07-30 03:04:19
Subject: Re: Sun inline assembler ...
Previous:From: Bruce MomjianDate: 2005-07-30 02:13:33
Subject: Re: BUG #1751: pg_restore bug

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group