Thread: plpgsql: How to catch error when I drop an inexistent table?

plpgsql: How to catch error when I drop an inexistent table?

From

Conxita Marín

Date:

11 December 2002, 06:21:23

Hi.
I'm trying to write a function that works with a temporary  table. I have to
be sure that when I execute the function,  it create it. Then I make a DROP
TABLE and after a CREATE TABLE. But if the table doesn't exists, the DROP
statement raises an error and the function stops. How can I resolve this
problem?

Thanks.

Conxita