Horton

Re: more ALTER .. DEPENDS ON EXTENSION fixes

Alvaro Herrera <alvherre@2ndquadrant.com>

View thread View on postgr.es
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Pg Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2020-02-17T23:56:03Z
Lists: pgsql-hackers

Attachments

On 2020-Feb-17, Alvaro Herrera wrote:

> * 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.

Here's these two patches.  There's an "if (true)" in 0002 which is a
little weird -- that's there just to avoid reindenting those lines in
0003.

In principle, I would think that these are all backpatchable bugfixes.
Maybe 0002 could pass as not backpatchable since it disallows a command
that works today.  OTOH the feature is rarely used, so maybe a backpatch
is not welcome anyhow.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Commits

  1. Add tab-completion for ALTER INDEX .. [NO] DEPENDS ON

  2. Add ALTER .. NO DEPENDS ON

  3. Add pg_dump support for ALTER obj DEPENDS ON EXTENSION

  4. Avoid duplicates in ALTER ... DEPENDS ON EXTENSION