pgsql: Accept relations of any kind in LOCK TABLE
| От | Alvaro Herrera |
|---|---|
| Тема | pgsql: Accept relations of any kind in LOCK TABLE |
| Дата | |
| Msg-id | E1kXSB5-0002X0-17@gemulon.postgresql.org обсуждение исходный текст |
| Список | pgsql-committers |
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 Branch ------ REL_11_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/2d1c7e64fe167a331e808b1e96b2a20f2a300b9e 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(-)
В списке pgsql-committers по дате отправления: