Re: Database Upgrade scripts (AKA Conditional SQL execution)

Поиск
Список
Период
Сортировка
От Joe Conway
Тема Re: Database Upgrade scripts (AKA Conditional SQL execution)
Дата
Msg-id 3F098FA5.4000808@joeconway.com
обсуждение исходный текст
Ответ на Database Upgrade scripts (AKA Conditional SQL execution)  (Richard Rowell <richard@bowmansystems.com>)
Список pgsql-sql
Richard Rowell wrote:
> Can I accomplish this with postgresql without involving an external
> process (like say perl)?  I guess I could put the upgrade stuff into
> PL/SQL functions and just drop the functions when I'm done, but I was
> hoping for something a little "cleaner".
> 

There is no way (currently at least) to do this without some kind of 
function. I've done it in the past with PL/pgSQL. We've had brief 
discussions in the past about how this could be supported, but nothing 
conclusive, and no one has cared enough to scratch this particular itch.

Joe



В списке pgsql-sql по дате отправления:

Предыдущее
От: Gary Stainburn
Дата:
Сообщение: Re: Concat and view - Re: create view error
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Concat and view - Re: create view error