Re: Idempotent DDL Updates

Поиск
Список
Период
Сортировка
От Julien Rouhaud
Тема Re: Idempotent DDL Updates
Дата
Msg-id CAOBaU_Ztc-8-NOrS=uAmZHG9mQ2HvdFuZApnd6+MqiaMvmgXOQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Idempotent DDL Updates  (Miles Elam <miles.elam@productops.com>)
Список pgsql-general
On Mon, Aug 30, 2021 at 11:56 PM Miles Elam <miles.elam@productops.com> wrote:
>
> Not sure that querying the catalogs is strictly necessary though… Could you say more?

I meant for anything that doesn't have an IF [NOT] EXISTS, including
cases where such a clause wouldn't be possible.  For instance if you
have to provide an upgrade script that change a column datatype.

As Adrian mentioned, sqitch should provide a sensible framework for
that, but there may be similar tools more suitable for your
environment if you're already using other frameworks.



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

Предыдущее
От: Vijaykumar Jain
Дата:
Сообщение: Re: vacuum full
Следующее
От: Ninad Shah
Дата:
Сообщение: Re: Issue with a query while running on a remote host