postgresql ddl scripts - drop object fails entire script - Mailing list pgsql-general

On the one hand I like how the schema scripts fail when there is a
single problem with a DDL statement.

On the other hand sometimes it is a pain - especially to take out all
the 'drop sequence', 'drop table' etc commands when creating a new
database.

Is there a 'drop if doesnt exist' or a better way of doing it?

thanks


pgsql-general by date:

Previous
From: Asok Chattopadhyay
Date:
Subject: Transaction is read-only in auto commit mode
Next
From: Jorge Godoy
Date:
Subject: Documenting stored procedures and functions