On Fri, Nov 19, 2004 at 21:38:33 -0800,
Baldeep Hira <baldeephira@gmail.com> wrote:
>
> I am able to drop tables in PostgreSQL, but the problem arises when
> the table does not exist and I try to execute a "drop table" command.
The simplest fix is to do the drop table outside of a transaction (so
that the error in the drop doesn't break the rest of your script).
If that won't work for you then you can write a custom function that
looks in the system catalog to see if the table exists before trying
the drop.
