Re: pg_dump not dumping some schemas

Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)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