pgsql: Drop global objects after completed test

Drop global objects after completed test

Project policy is to not leave global objects behind after a regress
test run. This was found as a result of the development of a patch
to make pg_regress detect such leftovers automatically, which in the
end was withdrawn due to issues with parallel runs.

This was originally committed as 936e3fa3787a, but the issue also exists
in the 12~16 range.

Discussion: https://postgr.es/m/E1phvk7-000VAH-7k@gemulon.postgresql.org
Backpatch-through: 12

Branch
------
REL_12_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/8ec99d0b79b236c14660ff2f3beb6ee9747e8f5c
Author: Daniel Gustafsson <dgustafsson(at)postgresql(dot)org>

Modified Files
--------------
src/test/modules/test_pg_dump/expected/test_pg_dump.out | 2 ++
src/test/modules/test_pg_dump/sql/test_pg_dump.sql | 4 ++++
2 files changed, 6 insertions(+)