Change of extension name to new name

From: Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Change of extension name to new name
Date: 2016-10-13 04:10:45
Message-ID: CAJrrPGfH0oLnbCz+rz9azStEcQWJ5AokGwVX-m_NDF0d7wFmWA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi All,

As we are planning to change an extension name from one name to another
name because of additional features that are added into this extension, so
the name is not matching, so we decided
to change the name, but it is causing problem to the already existing
installations with old extension
name tries to upgrade to a new version.

9.5 + 'extension_name1' -> 9.6 + 'extension_name2' fails during pg_upgrade
when it tries to load
the extension and it's object dependencies on 9.6. If we keep the same
extension name then it passed.

Is there any possibility to change the extension name without causing the
pg_upgrade failure with minimal changes?

I just thought of adding the support of (ALTER EXTENSION name RENAME To
newname), this can be executed before executing the pg_upgrade to the new
extension name that is available in the
newer version.

Is there any simpler way to change the extension name, if not any opinion
about adding the syntax support to rename an extension?

Regards,
Hari Babu
Fujitsu Australia

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Haribabu Kommi 2016-10-13 04:12:10 Re: macaddr 64 bit (EUI-64) datatype support
Previous Message Tatsuo Ishii 2016-10-13 03:53:52 Re: parallel.sgml