On 5 July 2011 21:27, Thom Brown <t...@linux.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers