Thread: pgsql: Add ALTER .. NO DEPENDS ON
Add ALTER .. NO DEPENDS ON Commit f2fcad27d59c (9.6 era) added the ability to mark objects as dependent an extension, but forgot to add a way for such dependencies to be removed. This commit fixes that oversight. Strictly speaking this should be backpatched to 9.6, but due to lack of demand we're not doing so at this time. Discussion: https://postgr.es/m/20200217225333.GA30974@alvherre.pgsql Reviewed-by: ahsan hadi <ahsan.hadi@gmail.com> Reviewed-by: Ibrar Ahmed <ibrar.ahmad@gmail.com> Reviewed-by: Tom Lane <tgl@sss.pgh.pa.us> Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/5fc703946bf3b18642ce83b937671d254a8ac5b5 Modified Files -------------- doc/src/sgml/ref/alter_function.sgml | 10 +++-- doc/src/sgml/ref/alter_index.sgml | 9 ++-- doc/src/sgml/ref/alter_materialized_view.sgml | 11 ++--- doc/src/sgml/ref/alter_trigger.sgml | 7 +++- src/backend/catalog/pg_depend.c | 49 ++++++++++++++++++++++ src/backend/commands/alter.c | 24 +++++++---- src/backend/nodes/copyfuncs.c | 1 + src/backend/nodes/equalfuncs.c | 1 + src/backend/parser/gram.y | 36 ++++++++++------ src/include/catalog/dependency.h | 4 ++ src/include/nodes/parsenodes.h | 1 + .../test_extensions/expected/test_extdepend.out | 34 +++++++++++++++ .../modules/test_extensions/sql/test_extdepend.sql | 17 +++++++- 13 files changed, 168 insertions(+), 36 deletions(-)