pgsql: Revert: Custom reloptions for table AM

Revert: Custom reloptions for table AM

This commit reverts 9bd99f4c26 and 422041542f per review by Andres Freund.

Discussion: https://postgr.es/m/20240410165236.rwyrny7ihi4ddxw4%40awork3.anarazel.de

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/bc1e2092ebb857802a9713d0d3588079e2f0216a

Modified Files
--------------
src/backend/access/common/reloptions.c | 149 +++++----------------
src/backend/access/heap/heapam.c | 4 +-
src/backend/access/heap/heapam_handler.c | 13 --
src/backend/access/heap/heaptoast.c | 9 +-
src/backend/access/heap/hio.c | 4 +-
src/backend/access/heap/pruneheap.c | 4 +-
src/backend/access/heap/rewriteheap.c | 4 +-
src/backend/access/table/tableam.c | 2 +-
src/backend/access/table/tableamapi.c | 25 ----
src/backend/commands/createas.c | 13 +-
src/backend/commands/tablecmds.c | 63 ++++-----
src/backend/commands/vacuum.c | 8 +-
src/backend/postmaster/autovacuum.c | 13 +-
src/backend/tcop/utility.c | 28 +---
src/backend/utils/cache/relcache.c | 54 +-------
src/include/access/reloptions.h | 11 +-
src/include/access/tableam.h | 50 -------
src/include/utils/rel.h | 148 ++++++++++----------
src/test/modules/Makefile | 1 -
src/test/modules/meson.build | 1 -
src/test/modules/test_tam_options/.gitignore | 4 -
src/test/modules/test_tam_options/Makefile | 23 ----
.../test_tam_options/expected/test_tam_options.out | 36 -----
src/test/modules/test_tam_options/meson.build | 33 -----
.../test_tam_options/sql/test_tam_options.sql | 25 ----
.../test_tam_options/test_tam_options--1.0.sql | 12 --
.../modules/test_tam_options/test_tam_options.c | 66 ---------
.../test_tam_options/test_tam_options.control | 4 -
src/tools/pgindent/typedefs.list | 4 +-
29 files changed, 161 insertions(+), 650 deletions(-)