Re: Reducing some DDL Locks to ShareLock - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Reducing some DDL Locks to ShareLock
Date
Msg-id 28372.1223333855@sss.pgh.pa.us
Whole thread Raw
In response to Reducing some DDL Locks to ShareLock  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Reducing some DDL Locks to ShareLock
List pgsql-hackers
Simon Riggs <simon@2ndQuadrant.com> writes:
> It seems possible to change some DDL commands/subcommands to use a
> ShareLock rather than an AccessExclusiveLock. Enclosed patch implements
> this reduction for CREATE TRIGGER, CREATE RULE and ALTER TABLE.

What happens when two transactions try to do one of these things
concurrently to the same table?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Grzegorz Jaskiewicz
Date:
Subject: problems with initdb after last cvs up
Next
From: Tom Lane
Date:
Subject: Re: Shouldn't pg_settings.enumvals be array of text?