Hi,
I have a problem in that I need to drop non-existent tables in a DDL
script. This is in order that the script can re-build a database schema
if the tables already exist. However, in Postgres this is proving to be
a problem because if the table does not exist then the DDL execution
will stop once it gets an error. I know that I can create a custom
function that will check the relevant postGres table to see if the table
already exists, but I don't want to do this as I would like to keep the
DDL as non-proprietary as possible. Anyone any ideas on a work-around
for this problem that does not involve creating a custom function.
thanks,
Richie.