On Fri, Nov 19, 2004 at 21:38:33 -0800, Baldeep Hira <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
