pgsql: Drop "Lock" suffix from LWLock wait event names

Drop "Lock" suffix from LWLock wait event names

Commit da952b415f44 unintentially reverted the SQL-visible part of
commit 14a910109126, which breaks queries joining pg_wait_events with
pg_stat_acivity.  Remove the suffix again.

Backpatch to 17.

Reported-by: Christophe Courtois <christophe.courtois@dalibo.com>
Author: Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Discussion: https://postgr.es/m/18728-450924477056a339%40postgresql.org
Discussion: https://postgr.es/m/Z01w1+LihtRiS0Te@ip-10-97-1-34.eu-west-3.compute.internal

Branch
------
REL_17_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/5ffbbcfa160b2e689dfb0542dfdbc4e16fc0dec9

Modified Files
--------------
src/backend/storage/lmgr/generate-lwlocknames.pl | 1 +
src/backend/storage/lmgr/lwlock.c                | 4 ++--
2 files changed, 3 insertions(+), 2 deletions(-)