plpgsql: How to catch error when I drop an inexistent table? - Mailing list pgsql-novice

From Conxita Marín
Subject plpgsql: How to catch error when I drop an inexistent table?
Date
Msg-id 000001c2a0ee$470d26a0$0cd8a8c0@dims
Whole thread Raw
List pgsql-novice
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


pgsql-novice by date:

Previous
From: Sol
Date:
Subject: Re: How many connections can a Postgress database support...
Next
From: Harry
Date:
Subject: Re: aggregating into 2 dimensions?