| From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | pgsql-patches <pgsql-patches(at)postgresql(dot)org> |
| Subject: | options for RAISE statement |
| Date: | 2008-04-16 11:30:02 |
| Message-ID: | 162867790804160430r2a51eacfv755a9efa838f1c3e@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
Hello
this patch adds possibility to set additional options (SQLSTATE,
DETAIL, DETAIL_LOG and HINT) for RAISE statement,
Proposal: http://archives.postgresql.org/pgsql-hackers/2008-04/msg00919.php
I changed keyword from WITH to USING, because I don't would to create
new keyword
RAISE level 'format' [, expression [, ...]] [ USING ( option =
expression [, ... ] ) ];
RAISE EXCEPTION 'Nonexistent ID --> %', user_id
USING (hint = 'Please, check your user id');
Regards
Pavel Stehule
| Attachment | Content-Type | Size |
|---|---|---|
| raise-options.diff | text/x-patch | 10.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | kenneth d'souza | 2008-04-16 12:00:40 | Re: Reference by output in : \d <table_name> |
| Previous Message | Simon Riggs | 2008-04-16 10:07:09 | Re: Improve shutdown during online backup |