Drop "Lock" suffix from LWLock wait event names

Álvaro Herrera <alvherre@alvh.no-ip.org>

Commit: 5ffbbcfa160b2e689dfb0542dfdbc4e16fc0dec9
Author: Álvaro Herrera <alvherre@alvh.no-ip.org>
Date: 2024-12-03T14:50:03Z
Releases: 17.3
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

Files

Discussion