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

options for RAISE statement

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 (view raw or flat)
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: raise-options.diff
Description: text/x-patch (10.7 KB)

Responses

pgsql-patches by date

Next:From: kenneth d'souzaDate: 2008-04-16 12:00:40
Subject: Re: Reference by output in : \d <table_name>
Previous:From: Simon RiggsDate: 2008-04-16 10:07:09
Subject: Re: Improve shutdown during online backup

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