Обсуждение: postgresql ddl scripts - drop object fails entire script

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

am  Sun, dem 24.09.2006, um 18:45:12 -0700 mailte timasmith@hotmail.com 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: 035242/47215,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

timasmith@hotmail.com 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 available, maybe wrapping your DDL statements in a pl/pgsql
SP will work. pl/pgsql has exceptions...
I haven't tried this, but I expect it will work.

--
Alban Hertroys
alban@magproductions.nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
    7500 AK Enschede

// Integrate Your World //

timasmith@hotmail.com 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
alban@magproductions.nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
    7500 AK Enschede

// Integrate Your World //