User's exception plpgsql

From: Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz>
To: pgsql-patches(at)postgresql(dot)org
Subject: User's exception plpgsql
Date: 2005-06-26 07:21:44
Message-ID: Pine.LNX.4.44.0506260904040.21791-200000@kix.fsv.cvut.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers 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 Content-Type Size
usrexcpt.diff text/plain 23.3 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Oleg Bartunov 2005-06-26 07:26:12 Re: Open items
Previous Message Pavel Stehule 2005-06-26 07:03:26 pl/pgsql: END verbosity [patch]

Browse pgsql-patches by date

  From Date Subject
Next Message Pavel Stehule 2005-06-26 07:50:23 ToDo: Allow PL/pgSQL EXECUTE query_var INTO record_var;
Previous Message Pavel Stehule 2005-06-26 07:03:26 pl/pgsql: END verbosity [patch]