Re: question about temp table in function

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!