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.