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

BUG #3065: Bug in stored procedure EXEPTION handling or in plpgsql ?

From: "Fridman Garri" <garri(at)wanadoo(dot)nl>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3065: Bug in stored procedure EXEPTION handling or in plpgsql ?
Date: 2007-02-23 17:26:40
Message-ID: 200702231726.l1NHQeZ5037417@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      3065
Logged by:          Fridman Garri
Email address:      garri(at)wanadoo(dot)nl
PostgreSQL version: 8.2.0
Operating system:   WinXP-Prof SP2
Description:        Bug in stored procedure EXEPTION handling or in plpgsql
?
Details: 

If I call "select message from mytest(5);" from command line or from Admin
III when a programm terminates with a Message:
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.

Stored Procedure "mytest" Created Successfully before running of examples.


Examples of situation: 
-- Example 1: no Crash
select message from mytest(-1);


-- Example 2: no Crash
select message from mytest(0);

-- Example 3: no Crash
select message from mytest(2);

-- Example 4: Crash !!!
select message from mytest(5);


-- Used Stored Procedure --
CREATE OR REPLACE FUNCTION mytest(IN amount "int4", OUT message "varchar") 
AS

$BODY$

DECLARE
myid integer;
BEGIN
            message = 'no errors';

            IF amount > 0
            THEN 
                  SELECT id INTO myid FROM client WHERE id = 1;
            END IF;

            IF amount = 0 OR amount = 5
            THEN
                  RAISE EXCEPTION 'error: amount = %', amount;
            END IF;

EXCEPTION
        WHEN OTHERS THEN
                  message = SQLERRM;
END;


$BODY$
  LANGUAGE 'plpgsql';
ALTER FUNCTION mytest(IN amount "int4", OUT message "varchar") OWNER TO
garri


Best regards.
Garri Fridman.

pgsql-bugs by date

Next:From: Peter EisentrautDate: 2007-02-23 18:32:10
Subject: Re: BUG #3038: information_schema.constraint_column_usage has wrong information for foreign keys
Previous:From: Fridman GarriDate: 2007-02-23 17:14:51
Subject: BUG #3064: In Stored Procedures (pgplgql

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