From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
---|---|
To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | pgsql: Add ALTER .. NO DEPENDS ON |
Date: | 2020-04-20 17:47:58 |
Message-ID: | E1jQaWU-00013l-9e@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
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(dot)hadi(at)gmail(dot)com>
Reviewed-by: Ibrar Ahmed <ibrar(dot)ahmad(at)gmail(dot)com>
Reviewed-by: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2020-04-20 18:41:54 | pgsql: Move the server's backup manifest code to a separate file. |
Previous Message | Tom Lane | 2020-04-20 16:29:46 | pgsql: Doc: update sections 9.5 and 9.6 for new function table layout. |