Add ALTER EXTENSION ADD/DROP ACCESS METHOD, and use it in pg_upgrade

Enterprise / PostgreSQL - Tom Lane [sss.pgh.pa.us] - 2 October 2016 13:31 UTC

Without this, an extension containing an access method is not properly dumped/restored during pg_upgrade --- the AM ends up not being a member of the extension after upgrading.

Another oversight in commit 473b93287, reported by Andrew Dunstan.

Report:

e8bdee2 Add ALTER EXTENSION ADD/DROP ACCESS METHOD, and use it in pg_upgrade.
doc/src/sgml/ref/alter_extension.sgml | 1 +
src/backend/parser/gram.y | 11 ++++++++++-
src/bin/pg_dump/pg_dump.c | 3 +++
3 files changed, 14 insertions(+), 1 deletion(-)

Upstream: git.postgresql.org

  • Share