Re: Intentionally produce Errors

[Andreas Seltenreich <andreas+pg@xxxxxxxxxxxxxxxxxx>]

Markus Schiltknecht writes:

> Matthias.Pitzl@xxxxxx wrote:
>> In PL/pgSQL you could use the RAISE command:
>> http://www.postgresql.org/docs/8.1/interactive/plpgsql-errors-and-messages.h
>> tml
>
> Thank you, good to know. Unfortunately I'm not in a PL/PgSQL function,
> just a plain query. Some standard functions which invoke RAISE?

I don't think there is any.  Maybe wrapping `raise exception' with a
function would work for you?  I'm using the following function to
raise exceptions from plain sql.

--8<---------------cut here---------------start------------->8---
create function error(text) returns void as $$
       begin
               raise exception '%', $1;
       end
       $$ language plpgsql;
--8<---------------cut here---------------end--------------->8---

However,

,----[ (info "(postgres)Errors and Messages") ]
|    `RAISE EXCEPTION' presently always generates the same SQLSTATE code,
| `P0001', no matter what message it is invoked with.
`----

regards,
andreas