Re: [GENERAL] Intentionally produce Errors

2006-10-10 Thread Alban Hertroys
Andreas Seltenreich wrote: Markus Schiltknecht writes: [EMAIL PROTECTED] wrote: --8<---cut here---start->8--- create function error(text) returns void as $$ begin raise exception '%', $1; end $$ language plpgsql; --8<

Re: [GENERAL] Intentionally produce Errors

2006-10-09 Thread Andreas Seltenreich
Markus Schiltknecht writes: > [EMAIL PROTECTED] 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 standa

Re: [GENERAL] Intentionally produce Errors

2006-10-09 Thread Markus Schiltknecht
Hello Matthias, [EMAIL PROTECTED] 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 invok

Re: [GENERAL] Intentionally produce Errors

2006-10-09 Thread Matthias . Pitzl
In PL/pgSQL you could use the RAISE command: http://www.postgresql.org/docs/8.1/interactive/plpgsql-errors-and-messages.h tml Best regards, Matthias > -Original Message- > > Hi, > > this is sort of a silly question, but: what's the proper way to > intentionally generate an error? I'm w