Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 261949FB229 for ; Mon, 23 Oct 2006 17:07:37 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 94766-08 for ; Mon, 23 Oct 2006 20:07:26 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from gmp-ea-fw-1.sun.com (gmp-ea-fw-1.sun.com [192.18.1.36]) by postgresql.org (Postfix) with ESMTP id 229939FB2F5 for ; Mon, 23 Oct 2006 17:07:25 -0300 (ADT) Received: from d1-emea-09.sun.com ([192.18.2.119]) by gmp-ea-fw-1.sun.com (8.13.6+Sun/8.12.9) with ESMTP id k9NK7K5j024437 for ; Mon, 23 Oct 2006 21:07:24 +0100 (BST) Received: from conversion-daemon.d1-emea-09.sun.com by d1-emea-09.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) id <0J7L00101UINIA00@d1-emea-09.sun.com> (original mail from Zdenek.Kotala@Sun.COM) for pgsql-hackers@postgresql.org; Mon, 23 Oct 2006 21:07:20 +0100 (BST) Received: from [129.150.120.213] by d1-emea-09.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPSA id <0J7L007CQUK8D3N0@d1-emea-09.sun.com>; Mon, 23 Oct 2006 21:07:20 +0100 (BST) Date: Mon, 23 Oct 2006 22:03:42 +0200 From: Zdenek Kotala Subject: Re: COPY does not work with regproc and aclitem In-reply-to: <453D1EBF.5070506@dunslane.net> To: Andrew Dunstan Cc: pgsql-hackers@postgresql.org Message-id: <453D201E.3070202@sun.com> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7BIT References: <453D1B73.2050906@sun.com> <453D1EBF.5070506@dunslane.net> User-Agent: Mail/News 1.5 (X11/20051211) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=UNPARSEABLE_RELAY X-Spam-Level: X-Archive-Number: 200610/1236 X-Sequence-Number: 93133 Andrew Dunstan wrote: > Zdenek Kotala wrote: >> I tried to use COPY command to export and import tables from catalog > > > Is it just me or does this seem like a strange thing to want to do? I am > trying to think of a good use case, so far without much success. > I'm playing with catalog upgrade. The very basic idea of my experiment is export data from catalog and import it back to the new initialized/fresh catalog. Zdenek