postgresql ddl scripts - drop object fails entire script

From: timasmith(at)hotmail(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: postgresql ddl scripts - drop object fails entire script
Date: 2006-09-25 01:45:12
Message-ID: 1159148712.800074.170600@h48g2000cwc.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bob Pawley 2006-09-25 02:03:29 Re: serial column
Previous Message Bob Pawley 2006-09-25 01:34:29 Re: serial column