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 <[email protected]> Reviewed-by: Tom Lane <[email protected]> Reported-by: Wells Oliver <[email protected]> Discussion: https://postgr.es/m/[email protected] Branch ------ REL_13_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/272bff6a35ef85b0226ac536c58ca24881c3c8d2 Modified Files -------------- doc/src/sgml/ref/lock.sgml | 15 +++++++++------ src/backend/commands/lockcmds.c | 28 +++++++++------------------- src/test/regress/expected/lock.out | 11 +++++++++++ src/test/regress/sql/lock.sql | 13 +++++++++++++ 4 files changed, 42 insertions(+), 25 deletions(-)
