Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 27EE4B5DBD1 for ; Mon, 16 May 2011 06:03:02 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 02355-02 for ; Mon, 16 May 2011 09:02:54 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sd-17937.dedibox.fr (sd-17937.dedibox.fr [88.191.100.74]) by mail.postgresql.org (Postfix) with ESMTP id BAACDB5D802 for ; Mon, 16 May 2011 06:02:54 -0300 (ADT) Received: from [192.168.10.3] (ASte-Genev-Bois-153-1-54-206.w81-249.abo.wanadoo.fr [81.249.148.206]) by sd-17937.dedibox.fr (Postfix) with ESMTPA id 683FB3B8F5; Mon, 16 May 2011 11:02:54 +0200 (CEST) Message-ID: <4DD0E83D.2050805@lelarge.info> Date: Mon, 16 May 2011 11:02:53 +0200 From: Guillaume Lelarge User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.17) Gecko/20110424 Thunderbird/3.1.10 MIME-Version: 1.0 To: Wells Oliver CC: pgsql-admin@postgresql.org Subject: Re: Dump/restore casts References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201105/98 X-Sequence-Number: 37535 Le 05/12/2011 03:52 AM, Wells Oliver a écrit : > If I'm understanding things, pg_dump will not dump casts b/c they are system > objects and belong to neither schema nor database. It doesn't dump system casts because they are system objects, and so always available. But it does dump user casts. -- Guillaume http://www.postgresql.fr http://dalibo.com