reply-to address broken (Was: Re: [GENERAL] postgresql ddl scripts - drop object fails entire script)

2006-09-27 Thread Alban Hertroys
[EMAIL PROTECTED] wrote: On the one hand I like how the schema scripts fail when there is a single problem with a DDL statement. Your mail address bounces. Unfortunately my Trash is broken, so I can't show you the error; I was a bit quick deleting it. -- Alban Hertroys [EMAIL PROTECTED] mag

Re: [GENERAL] postgresql ddl scripts - drop object fails entire script

2006-09-27 Thread Alban Hertroys
[EMAIL PROTECTED] wrote: 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. Until 8.2 is avail

Re: [GENERAL] postgresql ddl scripts - drop object fails entire script

2006-09-26 Thread A. Kretschmer
am Sun, dem 24.09.2006, um 18:45:12 -0700 mailte [EMAIL PROTECTED] folgendes: > Is there a 'drop if doesnt exist' or a better way of doing it? 8.2, read http://developer.postgresql.org/pgdocs/postgres/release-8-2.html DROP object IF EXISTS HTH, Andreas -- Andreas Kretschmer Kontakt: Heynitz:

[GENERAL] postgresql ddl scripts - drop object fails entire script

2006-09-26 Thread timasmith
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