Hi.
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.
Thanks,
Amit