Re: Changing extension schema fails silently

On 5 July 2011 21:27, Thom Brown <thom(at)linux(dot)com> wrote:
> Hi,
>
> I'm using the latest head and I created the file_fdw extension, then
> attempted to change its schema (ALTER EXTENSION file_fdw SET SCHEMA
> new_schema.  No error was returned, but it remained in the same schema
> (according to pg_extension).
>
> I then dropped the extension and created it again specifying the new
> schema, and it is correctly assigned to that schema.
>
> Am I missing something, or does this fail silently?

Correction, the objects which belong to the extension do switch
schema, but the properties of the extension itself indicate the
extension is in a different schema. So rather than not working at
all, it seems that it's just forgotten to update the pg_extension
catalog table.

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

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