Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 176869FB33B for ; Mon, 23 Oct 2006 17:18:10 -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 99136-04 for ; Mon, 23 Oct 2006 20:17:59 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from community1.commandprompt.com (host-130.commandprompt.net [207.173.203.130]) by postgresql.org (Postfix) with ESMTP id 796599FB229 for ; Mon, 23 Oct 2006 17:17:59 -0300 (ADT) Received: from [192.168.27.150] ([12.38.10.44]) (authenticated bits=0) by community1.commandprompt.com (8.13.5.20060308/8.13.5/Debian-3ubuntu1.1) with ESMTP id k9NKHuYG021864 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT); Mon, 23 Oct 2006 13:17:58 -0700 Message-ID: <453D2373.7010705@dunslane.net> Date: Mon, 23 Oct 2006 16:17:55 -0400 From: Andrew Dunstan User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.8.0.6) Gecko/20060804 Fedora/1.0.4-0.5.1.fc5 SeaMonkey/1.0.4 MIME-Version: 1.0 To: Zdenek Kotala CC: pgsql-hackers@postgresql.org Subject: Re: COPY does not work with regproc and aclitem References: <453D1B73.2050906@sun.com> <453D1EBF.5070506@dunslane.net> <453D201E.3070202@sun.com> In-Reply-To: <453D201E.3070202@sun.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200610/1239 X-Sequence-Number: 93136 Zdenek Kotala wrote: > 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. > > > Fair enough, but I am somewhat doubtful that COPY is the best way to do this. cheers andrew