pgsql: Revert: Allow locking updated tuples in tuple_update() and tuple

Revert: Allow locking updated tuples in tuple_update() and tuple_delete()

This commit reverts 87985cc925 and 818861eb57 per review by Andres Freund.

Discussion: https://postgr.es/m/20240410165236.rwyrny7ihi4ddxw4%40awork3.anarazel.de

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/193e6d18e553a104d315ff81892d509d89a30fd8

Modified Files
--------------
src/backend/access/heap/heapam.c         | 205 +++++-------------
src/backend/access/heap/heapam_handler.c |  93 ++------
src/backend/access/table/tableam.c       |  26 +--
src/backend/commands/trigger.c           |  55 +++--
src/backend/executor/execReplication.c   |  19 +-
src/backend/executor/nodeModifyTable.c   | 353 +++++++++++++++++--------------
src/include/access/heapam.h              |  19 +-
src/include/access/tableam.h             |  73 ++-----
src/include/commands/trigger.h           |   4 +-
9 files changed, 346 insertions(+), 501 deletions(-)