options for RAISE statement - Mailing list pgsql-patches

From Pavel Stehule
Subject options for RAISE statement
Date
Msg-id 162867790804160430r2a51eacfv755a9efa838f1c3e@mail.gmail.com
Whole thread Raw
Responses Re: options for RAISE statement  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: options for RAISE statement  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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

pgsql-patches by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Improve shutdown during online backup
Next
From: kenneth d'souza
Date:
Subject: Re: Reference by output in : \d