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!
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
