pgsql: Revert "For inplace update, send nontransactional invalidations.

Revert "For inplace update, send nontransactional invalidations."

This reverts commit 95c5acb3fc261067ab65ddc0b2dca8e162f09442 (v17) and
counterparts in each other non-master branch. If released, that commit
would have caused a worst-in-years minor release regression, via
undetected LWLock self-deadlock. This commit and its self-deadlock fix
warrant more bake time in the master branch.

Reported by Alexander Lakhin.

Discussion: https://postgr.es/m/10ec0bc3-5933-1189-6bb8-5dec4114558e@gmail.com

Branch
------
REL_14_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/4c708872950374dce23a61a1eba1411d9498d5d2

Modified Files
--------------
src/backend/access/heap/heapam.c | 43 +----
src/backend/access/transam/xact.c | 26 +--
src/backend/catalog/index.c | 11 +-
src/backend/replication/logical/decode.c | 26 +--
src/backend/utils/cache/catcache.c | 7 +-
src/backend/utils/cache/inval.c | 261 +++++++-------------------
src/backend/utils/cache/syscache.c | 3 +-
src/include/utils/catcache.h | 3 +-
src/include/utils/inval.h | 6 -
src/test/isolation/expected/inplace-inval.out | 10 +-
src/test/isolation/specs/inplace-inval.spec | 12 +-
11 files changed, 118 insertions(+), 290 deletions(-)