Re: pg_dump not dumping some schemas

Albe Laurenz <laurenz.albe@wien.gv.at> writes:
> Yun Guo wrote:
>> polling_etl=# SELECT classid, objid, refclassid, refobjid
>> FROM pg_depend
>> WHERE refclassid = 'pg_extension'::regclass
>> AND deptype = 'e'  and objid = 17972
>> ORDER BY 3,4;
>> classid | objid | refclassid | refobjid
>> ---------+-------+------------+----------
>> 2615 | 17972 |       3079 |    16730
>>
>> polling_etl=# select * from pg_extension where oid = 16730;
>> extname | extowner | extnamespace | extrelocatable | extversion |
>> extconfig | extcondition
>> ---------+----------+--------------+----------------+------------+---------
>> --+--------------
>> hstore  |       10 |        16389 | t              | 1.2        |
>> |
>>
>> How can I remove this dependency? Or what should I do to make it dump the
>> schema creation correctly?

> It *is* being dumped correctly.

Indeed.  What's more interesting to ask is how did the hstore extension
wind up owning a schema?  That should certainly not happen as shipped.
Were you playing around with ALTER EXTENSION ADD/DROP?

            regards, tom lane