Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Yzn5z-0002LA-15 for pgsql-admin@arkaria.postgresql.org; Tue, 02 Jun 2015 14:23:11 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Yzn5x-0003dL-Us for pgsql-admin@arkaria.postgresql.org; Tue, 02 Jun 2015 14:23:09 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Yzn5k-0003Im-7e for pgsql-admin@postgresql.org; Tue, 02 Jun 2015 14:22:56 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1Yzn5h-0004eq-47 for pgsql-admin@postgresql.org; Tue, 02 Jun 2015 14:22:54 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id t52EMph3028316; Tue, 2 Jun 2015 10:22:51 -0400 From: Tom Lane To: Albe Laurenz cc: "'Guo, Yun *EXTERN*'" , "pgsql-admin@postgresql.org" Subject: Re: pg_dump not dumping some schemas In-reply-to: References: <2DB6C5478F692C4C983B3129CC1AEB14CA65E8C8@HQ08HQMX002.cvent.net> <17196.1433168399@sss.pgh.pa.us> <11998.1433214088@sss.pgh.pa.us> Comments: In-reply-to Albe Laurenz message dated "Tue, 02 Jun 2015 14:02:46 -0000" Date: Tue, 02 Jun 2015 10:22:51 -0400 Message-ID: <28315.1433254971@sss.pgh.pa.us> X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Albe Laurenz 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin