Albe Laurenz <laurenz.albe@xxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
