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

From timasmith@hotmail.com
Subject postgresql ddl scripts - drop object fails entire script
Date
Msg-id 1159148712.800074.170600@h48g2000cwc.googlegroups.com
Whole thread Raw
Responses Re: postgresql ddl scripts - drop object fails entire script  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: postgresql ddl scripts - drop object fails entire script  (Alban Hertroys <alban@magproductions.nl>)
reply-to address broken (Was: Re: postgresql ddl scripts - drop object fails entire script)  (Alban Hertroys <alban@magproductions.nl>)
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