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(-)