On Wed, Jul 4, 2018 at 3:09 AM, Amit Langote
<Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> wrote:
> I wonder why we mention on the following page that CREATE COLLATION
> requires SHARE ROW EXCLUSIVE lock
>
> https://www.postgresql.org/docs/devel/static/explicit-locking.html
>
> I know that's the lock taken on the pg_collation catalog, but do we need
> to mention locks taken by a DDL command on the catalogs it affects? All
> other commands mentioned on the page require to specify the table name
> that the lock will be taken on.
Yes, that looks odd.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company