Re: Changing extension schema fails silently

On 5 July 2011 22:31, Peter Geoghegan <peter(at)2ndquadrant(dot)com> wrote:
> From the docs:
>
> Note that unlike most catalogs with a "namespace" column, extnamespace
> is not meant to imply that the extension belongs to that schema.
> Extension names are never schema-qualified. Rather, extnamespace
> indicates the schema that contains most or all of the extension's
> objects. If extrelocatable is true, then this schema must in fact
> contain all schema-qualifiable objects belonging to the extension.
>
> However, if you look at the source, the function
> AlterExtensionNamespace(List *names, const char *newschema) has this
> line:
>
> /* Now adjust pg_extension.extnamespace */
> extForm->extnamespace = nspOid;
>
> So clearly the catalog column ought to have been updated. I can't
> recreate the problem here, and I too am working from git head on the
> master branch.

D'oh, I've discovered the problem. It's my copy of PgAdmin that was
reporting the wrong name. Nothing to see here.

--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company