postgresql ddl scripts - drop object fails entire script

Поиск
Список
Период
Сортировка
От timasmith@hotmail.com
Тема postgresql ddl scripts - drop object fails entire script
Дата
Msg-id 1159148712.800074.170600@h48g2000cwc.googlegroups.com
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Asok Chattopadhyay
Дата:
Сообщение: Transaction is read-only in auto commit mode
Следующее
От: Jorge Godoy
Дата:
Сообщение: Documenting stored procedures and functions