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_16_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/6f9dd2282e37589bdadf15423b0395ce11735f82

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               | 304 ++++++++------------------
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 +-
src/tools/pgindent/typedefs.list              |   1 -
12 files changed, 132 insertions(+), 320 deletions(-)