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

Re: Another plpgsql crash

From: Robert Hentosh <hentosh(at)io(dot)com>
To: bs(at)niggard(dot)org, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Another plpgsql crash
Date: 2001-05-09 14:07:42
Message-ID: 20010509090742.B4794@eris.io.com (view raw or flat)
Thread:
Lists: pgsql-bugs
See reply to your previous bug report. 7.1 doesn't have this problem or fetch
the latest from CVS's REL7_1_STABLE branch.


On Wed, May 09, 2001 at 09:15:16AM -0400, pgsql-bugs(at)postgresql(dot)org wrote:
>  (bs(at)niggard(dot)org) reports a bug with a severity of 2
> The lower the number the more severe it is.
> 
> Short Description
> Another plpgsql crash
> 
> Long Description
> Ok, just found another one:
> The function crashes, when the corresponding user is not found.
> 
> This one just looks too common, so i guess i messed up installation?
> 
> Sample Code
> CREATE FUNCTION "new_news" (varchar ) RETURNS int4 AS '
> DECLARE     
> 	letzte_nachricht_p INT4;
> BEGIN
> 	SELECT letzte_nachricht INTO letzte_nachricht_p FROM luser WHERE uid = $1;
> END;
> ' LANGUAGE 'plpgsql';
> 
> 
> No file was uploaded with this report
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2001-05-09 15:03:38
Subject: Re: PostgreSQL 7.1.1: Backend crash when calling plpgsql function
Previous:From: Robert HentoshDate: 2001-05-09 14:06:12
Subject: Re: PostgreSQL 7.1.1: Backend crash when calling plpgsql function

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