more ALTER .. DEPENDS ON EXTENSION fixes

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Pg Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: more ALTER .. DEPENDS ON EXTENSION fixes
Date: 2020-02-17 22:53:33
Message-ID: 20200217225333.GA30974@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

ALTER ... DEPENDS ON EXTENSION (dependencies of type 'x' on an
extension) was found to have a few problems. One was fixed as
CVE-2020-1720. Other issues:

* pg_dump does not reproduce database state correctly.
The attached 0000 fixes it.

* More than one 'x' dependencies are allowed for the same object on the
same extension. That's useless and polluting, so should be prevented.

* There's no way to remove an 'x' dependency.

I'll send patches for the other two issues as replies later. (I
discovered an issue in my 0001, for the second one, just as I was
sending.)

--
Álvaro Herrera

Attachment Content-Type Size
0001-Add-pg_dump-support-for-ALTER-object-DEPENDS-ON-EXTE.patch text/x-diff 10.1 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jesse Zhang 2020-02-17 22:57:59 Re: Resolving the python 2 -> python 3 mess
Previous Message Thomas Munro 2020-02-17 22:46:48 Re: pgindent && weirdness