pgsql: Revert "Accept relations of any kind in LOCK TABLE".

Revert "Accept relations of any kind in LOCK TABLE".

Revert 59ab4ac32, as well as the followup fix 33862cb9c, 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/16703-e348f58aab3cf6cc@postgresql.org

Branch
------
REL9_6_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/9e555180f23dd4d1a85a8b2b93350358322a540a

Modified Files
--------------
doc/src/sgml/ref/lock.sgml         | 24 ++++++++----------------
src/backend/commands/lockcmds.c    |  7 +++++++
src/test/regress/expected/lock.out | 16 +++-------------
src/test/regress/sql/lock.sql      | 17 ++---------------
4 files changed, 20 insertions(+), 44 deletions(-)