pgsql: Revert "pg_dump: Lock all relations, not just plain tables".

Revert "pg_dump: Lock all relations, not just plain tables".

Revert 403a3d91c, as well as the followup fix 7f4235032, in all
branches. We need to think a bit harder about what the behavior
of LOCK TABLE on views should be, and there's no time for that
before next week's releases. We'll take another crack at this
later.

Discussion: https://postgr.es/m/[email protected]

Branch
------
REL_11_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/802c460a27cc1d01f8c8b9542488bbdfde60dc58

Modified Files
--------------
src/bin/pg_dump/pg_backup.h | 2 --
src/bin/pg_dump/pg_backup_db.c | 67 ------------------------------------------
src/bin/pg_dump/pg_backup_db.h | 2 --
src/bin/pg_dump/pg_dump.c | 17 +++++------
4 files changed, 7 insertions(+), 81 deletions(-)