Thread: pgsql: Add support for DEFAULT in ALTER TABLE .. SET ACCESS METHOD
Add support for DEFAULT in ALTER TABLE .. SET ACCESS METHOD This option can be used to switch a relation to use the access method set by default_table_access_method when running the command. This has come up when discussing the possibility to support setting pg_class.relam for partitioned tables (left out here as future work), while being useful on its own for relations with physical storage as these must have an access method set. Per suggestion from Justin Pryzby. Author: Michael Paquier Reviewed-by: Justin Pryzby Discussion: https://postgr.es/m/ZeCZ89xAVFeOmrQC@pryzbyj2023 Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/d61a6cad6418f643a5773352038d0dfe5d3535b8 Modified Files -------------- doc/src/sgml/ref/alter_table.sgml | 6 ++++-- src/backend/commands/tablecmds.c | 4 +++- src/backend/parser/gram.y | 10 ++++++++-- src/bin/psql/tab-complete.c | 3 ++- src/test/regress/expected/create_am.out | 23 +++++++++++++++++++++++ src/test/regress/sql/create_am.sql | 12 ++++++++++++ 6 files changed, 52 insertions(+), 6 deletions(-)