pgsql: isolationtester: append session name to application_name.

isolationtester: append session name to application_name.

When writing / debugging an isolation test it sometimes is useful to see which
session holds what lock etc. To make it easier, both as part of spec files and
interactively, append the session name to application_name. Since b1907d688
application_name already contains the test name, this appends the session's
name to that.

insert-conflict-specconflict did something like this manually, which can now
be removed.

As we have done lately with other test infrastructure improvements, backpatch
this change, to make it easier to backpatch tests.

Author: Andres Freund <andres@anarazel.de>
Reviewed-By: Michael Paquier <michael@paquier.xyz>
Reviewed-By: Andrew Dunstan <andrew@dunslane.net>
Discussion: https://postgr.es/m/20211211012052.2blmzcmxnxqawd2z@alap3.anarazel.de
Backpatch: 10-, to make backpatching of tests easier.

Branch
------
REL_14_STABLE

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

Modified Files
--------------
.../expected/insert-conflict-specconflict.out      | 20 ++++++++--------
src/test/isolation/isolationtester.c               | 28 ++++++++++++++++++++--
.../specs/insert-conflict-specconflict.spec        |  5 +---
3 files changed, 37 insertions(+), 16 deletions(-)