Re: Error in executing plpgsql function - Mailing list pgsql-sql

From Tom Lane
Subject Re: Error in executing plpgsql function
Date
Msg-id 18422.1007407387@sss.pgh.pa.us
Whole thread Raw
In response to Error in executing plpgsql function  (ananthreddy@yahoo.com (ananth))
List pgsql-sql
ananthreddy@yahoo.com (ananth) writes:
> The problem is when I run this function by passing a parameter values
> where row does not exist in table. I expect it to print message and
> return false. Instead it disconnects from server and throughs lot of
> errors in log file. Here is output from executing this function

What PG version are you running?  I seem to recall that there was a bug
with some not-found cases in plpgsql a while back.  If you're not using
7.1.3, update.
        regards, tom lane


pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: An easy question about creating a primary key
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: An easy question about creating a primary key