On Nov 16, 2004, at 2:11 PM, Michael Fuhr wrote:
> \set VERBOSITY verbose
> SELECT foo();
> ERROR: 42P01: table "my_temp" does not exist
> CONTEXT: SQL statement "DROP TABLE my_temp"
> PL/pgSQL function "foo" line 2 at SQL statement
> LOCATION: DropErrorMsgNonExistent, utility.c:144
>
> The error code is 42P01, which Appendix A shows as UNDEFINED TABLE.
> The exception-handling block would therefore be:
>
> BEGIN
> DROP TABLE my_temp;
> EXCEPTION
> WHEN undefined_table THEN
> NULL;
> END;
>
> --
> Michael Fuhr
> http://www.fuhr.org/~mfuhr/
>
That's exactly what I needed. I didn't think to set the verbosity to
get the error code. Thanks!