From: | Kenaniah Cerny <kenaniah(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Idempotency for all DDL statements |
Date: | 2016-10-17 18:05:49 |
Message-ID: | CA+r_aq8-ZfKd8cwydN1mQAzFQ3JrdcBHWMuEMt9_ofoKRam_6A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello everyone. This is my first time posting in -hackers, so please keep
this in mind.
I would like to formally request the addition of "IF EXISTS", "IF NOT
EXISTS", "OR REPLACE", and any other CINE variants to DDL statements that
currently do not feature an idempotent construct.
The lack of an idempotent option in statements such as "CREATE TRIGGER" for
example is particularly painful when performing upgrades on sizable
schemas.
I understand that there may be some difficulties in providing this to
various database objects. That said, I believe IMHO that this would be a
huge win for the community at large. Could I request DDL idempotency as an
addition to the development roadmap?
Thanks,
Kenaniah
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2016-10-17 18:14:23 | Re: Re: [COMMITTERS] pgsql: Replace PostmasterRandom() with a stronger way of generating ran |
Previous Message | Heikki Linnakangas | 2016-10-17 17:48:58 | Re: [COMMITTERS] pgsql: Replace PostmasterRandom() with a stronger way of generating ran |