agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Alex Ignatov <a.ignatov@postgrespro.ru>
To: pgsql-sql@postgresql.org
Subject: User defined exceptions
Date: Wed, 15 Jul 2015 17:10:18 +0300
Message-ID: <55A669CA.3070302@postgrespro.ru> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
Hello all!
Trying to emulate "named" user defined exception with:
CREATE OR REPLACE FUNCTION exception_aaa () RETURNS text AS $body$
BEGIN
return 31234;
END;
$body$
LANGUAGE PLPGSQL
SECURITY DEFINER
;
do $$
begin
raise exception using errcode=exception_aaa();
exception
when sqlstate exception_aaa()
then
raise notice 'got exception %',sqlstate;
end;
$$
Got:
ERROR: syntax error at or near "exception_aaa"
LINE 20: sqlstate exception_aaa()
I looks like "when sqlstate exception_aaa()" doesn't work.
How can I catch exception in this case?
--
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
view thread (6+ messages) latest in thread
Message-ID: <55A669CA.3070302@postgrespro.ru>
Permalink: ../55A669CA.3070302@postgrespro.ru/
Also on: postgresql.org/message-id/55A669CA.3070302@postgrespro.ru
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: a.ignatov@postgrespro.ru
Subject: Re: User defined exceptions
In-Reply-To: <55A669CA.3070302@postgrespro.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox