diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2020-10-27 13:49:19 -0300 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2020-10-27 13:49:19 -0300 |
| commit | 61ae9d6bc763599a01424c7967d7b034ba7f792e (patch) | |
| tree | 5cad828287e26fe103ba8ed57c5c017ee62215c8 /src/backend/commands/lockcmds.c | |
| parent | d6d7fb1aacbecf8c2813233ff7da2afb2ed029bc (diff) | |
| download | postgresql-61ae9d6bc763599a01424c7967d7b034ba7f792e.tar.gz postgresql-61ae9d6bc763599a01424c7967d7b034ba7f792e.zip | |
Accept relations of any kind in LOCK TABLE
The restriction that only tables and views can be locked by LOCK TABLE
is quite arbitrary, since the underlying mechanism can lock any relation
type. Drop the restriction so that programs such as pg_dump can lock
all relations they're interested in, preventing schema changes that
could cause a dump to fail after expending much effort.
Backpatch to 9.5.
Author: Álvaro Herrera <alvherre@alvh.no-ip.org>
Reviewed-by: Tom Lane <tgl@sss.pgh.pa.us>
Reported-by: Wells Oliver <wells.oliver@gmail.com>
Discussion: https://postgr.es/m/20201021200659.GA32358@alvherre.pgsql
Diffstat (limited to 'src/backend/commands/lockcmds.c')
| -rw-r--r-- | src/backend/commands/lockcmds.c | 7 |
1 files changed, 0 insertions, 7 deletions
diff --git a/src/backend/commands/lockcmds.c b/src/backend/commands/lockcmds.c index a1670821aa4..15b4c2f90ad 100644 --- a/src/backend/commands/lockcmds.c +++ b/src/backend/commands/lockcmds.c @@ -87,13 +87,6 @@ RangeVarCallbackForLockTable(const RangeVar *rv, Oid relid, Oid oldrelid, return; /* woops, concurrently dropped; no permissions * check */ - /* Currently, we only allow plain tables to be locked */ - if (relkind != RELKIND_RELATION) - ereport(ERROR, - (errcode(ERRCODE_WRONG_OBJECT_TYPE), - errmsg("\"%s\" is not a table", - rv->relname))); - /* Check permissions. */ aclresult = LockTableAclCheck(relid, lockmode); if (aclresult != ACLCHECK_OK) |