User's exception plpgsql - Mailing list pgsql-patches

From Pavel Stehule
Subject User's exception plpgsql
Date
Msg-id Pine.LNX.4.44.0506260904040.21791-200000@kix.fsv.cvut.cz
Whole thread Raw
In response to pl/pgsql: END verbosity [patch]  (Pavel Stehule <stehule@kix.fsv.cvut.cz>)
Responses Re: User's exception plpgsql
Re: User's exception plpgsql
List pgsql-patches
Hello

Per small recent discussion I corrected patch user's exception.

diff: User can choise any sqlstate (without class U0, which I reserve as
range for default values sqlstates - if user don't spec sqlstate, is
used value from this range). There is only basic changes in documentation
and needs enhancing. I am not able to do (I am sorry, my english is poor).

Note: patch don't create deep changes in plpgsql core. Only enhance stmts
DECLARE, RAISE and EXCEPTION condition.

Next ToDo (needs discussion):
  + Optional message in raise stmt for user's or system exception
      raise exception division_by_zero;
  + Possibility rethrown exception
      raise;

Regards
Pavel Stehule


Attachment

pgsql-patches by date:

Previous
From: Pavel Stehule
Date:
Subject: pl/pgsql: END verbosity [patch]
Next
From: Pavel Stehule
Date:
Subject: ToDo: Allow PL/pgSQL EXECUTE query_var INTO record_var;