Re: Idempotent DDL Updates - Mailing list pgsql-general

From Julien Rouhaud
Subject Re: Idempotent DDL Updates
Date
Msg-id CAOBaU_Ztc-8-NOrS=uAmZHG9mQ2HvdFuZApnd6+MqiaMvmgXOQ@mail.gmail.com
Whole thread Raw
In response to Re: Idempotent DDL Updates  (Miles Elam <miles.elam@productops.com>)
List 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 by date:

Previous
From: Vijaykumar Jain
Date:
Subject: Re: vacuum full
Next
From: Ninad Shah
Date:
Subject: Re: Issue with a query while running on a remote host