Add ALTER .. NO DEPENDS ON
authorAlvaro Herrera <alvherre@alvh.no-ip.org>
Mon, 20 Apr 2020 17:42:12 +0000 (13:42 -0400)
committerAlvaro Herrera <alvherre@alvh.no-ip.org>
Mon, 20 Apr 2020 17:42:12 +0000 (13:42 -0400)
commit5fc703946bf3b18642ce83b937671d254a8ac5b5
treee870c58ea48bbaa990e7c1c797d5357a7c880196
parent4157f73b4ba7fa0c6fb117cb9b5a771875850c83
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>
13 files changed:
doc/src/sgml/ref/alter_function.sgml
doc/src/sgml/ref/alter_index.sgml
doc/src/sgml/ref/alter_materialized_view.sgml
doc/src/sgml/ref/alter_trigger.sgml
src/backend/catalog/pg_depend.c
src/backend/commands/alter.c
src/backend/nodes/copyfuncs.c
src/backend/nodes/equalfuncs.c
src/backend/parser/gram.y
src/include/catalog/dependency.h
src/include/nodes/parsenodes.h
src/test/modules/test_extensions/expected/test_extdepend.out
src/test/modules/test_extensions/sql/test_extdepend.sql