git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 48e1291) | patch
Don't throw an error for LOCK TABLE on a self-referential view.
Thu, 5 Nov 2020 16:44:32 +0000 (11:44 -0500)
Thu, 5 Nov 2020 16:44:32 +0000 (11:44 -0500)
commit 5b7bfc39726ff9f6c52dd73e337c34e74e0d1f39
Don't throw an error for LOCK TABLE on a self-referential view.

LOCK TABLE has complained about "infinite recursion" when applied
to a self-referential view, ever since we made it recurse into views
in v11. However, that breaks pg_dump's new assumption that it's
okay to lock every relation. There doesn't seem to be any good
reason to throw an error: if we just abandon the recursion, we've
still satisfied the requirement of locking every referenced relation.

Per bug #16703 from Andrew Bille (via Alexander Lakhin).

Discussion: https://postgr.es/m/16703-e348f58aab3cf6cc@postgresql.org
src/backend/commands/lockcmds.c diff | blob | blame | history
src/test/regress/expected/lock.out diff | blob | blame | history
src/test/regress/sql/lock.sql diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

AltStyle によって変換されたページ (->オリジナル) /