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

Re: Backend crash in 8.2.3 with plpgsql function

From: Reece Hart <reece(at)harts(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: SM <sm(at)resistor(dot)net>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Backend crash in 8.2.3 with plpgsql function
Date: 2007-03-15 16:03:40
Message-ID: 1173974620.4954.9.camel@snafu.site (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackers
On Thu, 2007-03-15 at 01:40 -0400, Tom Lane wrote:
> SM <sm(at)resistor(dot)net> writes:
> > I got a backend crash in Postgresql 8.2.3 with the plpgsql function.
> > The following statement in psql causes a signal 11:
> > psql=# create function testpl() returns void as 'begin return; 
> > end;'language 'plpgsql';
> 
> Worksforme ... 

Works for me too.

csb=# select version();
                                                     version                                                      
------------------------------------------------------------------------------------------------------------------
 PostgreSQL 8.2.3 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.0.2 20050901 (prerelease) (SUSE Linux)
csb=# create function testpl() returns void as 'begin return; 
csb'# end;'language 'plpgsql';
CREATE FUNCTION
csb=# select testpl();
 testpl 
--------
 
(1 row)

-- 
Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0
./universe -G 6.672e-11 -e 1.602e-19 -protonmass 1.673e-27 -uspres bush
kernel warning: universe consuming too many resources. Killing.
universe killed due to catastrophic leadership. Try -uspres carter.


In response to

pgsql-hackers by date

Next:From: Teodor SigaevDate: 2007-03-15 16:17:54
Subject: tsearch_core for inclusion
Previous:From: A.M.Date: 2007-03-15 16:01:59
Subject: Re: My honours project - databases using dynamically attached entity-properties

pgsql-bugs by date

Next:From: Ralf BertelsmannDate: 2007-03-15 19:40:26
Subject: New role with password and error message
Previous:From: Gaetano MendolaDate: 2007-03-15 14:52:47
Subject: Re: Backend crash in 8.2.3 with plpgsql function

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