On 17 July 2018 at 19:47, Robert Haas wrote:
> On Mon, Jul 9, 2018 at 6:00 AM, Simon Riggs wrote:
>> Proposal would be to add a new lock mode "ShareUpdate", which does not
>> conflict with itself and yet conflicts with "ShareUpdateExclusive" or
>> higher. (Hence, it is a strong lock type). DDL wo
On Mon, Jul 9, 2018 at 6:00 AM, Simon Riggs wrote:
> Proposal would be to add a new lock mode "ShareUpdate", which does not
> conflict with itself and yet conflicts with "ShareUpdateExclusive" or
> higher. (Hence, it is a strong lock type). DDL would take a
> ShareUpdateLock on the table, then dur
We use the word CONCURRENTLY to describe DDL that executes without
preventing select, insert, update or delete against a table. That is
not the topic discussed here.
I've been asked if we could consider allowing more types of DDL to run
at the same time as each other. Specifically, that all/most o