Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id CD3EC9FB3B9; Thu, 26 Oct 2006 10:33:33 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 77549-05; Thu, 26 Oct 2006 10:33:27 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- 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 95B639FB3B4; Thu, 26 Oct 2006 10:33:26 -0300 (ADT) Received: from d1-emea-10.sun.com ([192.18.2.120]) by gmp-ea-fw-1.sun.com (8.13.6+Sun/8.12.9) with ESMTP id k9QDXOpv029071; Thu, 26 Oct 2006 14:33:24 +0100 (BST) Received: from conversion-daemon.d1-emea-10.sun.com by d1-emea-10.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) id <0J7Q00I01W68S300@d1-emea-10.sun.com> (original mail from Zdenek.Kotala@Sun.COM); Thu, 26 Oct 2006 14:33:24 +0100 (BST) Received: from [129.157.18.76] by d1-emea-10.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPSA id <0J7Q00FRRWBJT8QG@d1-emea-10.sun.com>; Thu, 26 Oct 2006 14:33:24 +0100 (BST) Date: Thu, 26 Oct 2006 15:31:30 +0200 From: Zdenek Kotala Subject: Re: [HACKERS] COPY does not work with regproc and aclitem In-reply-to: <7995.1161697174@sss.pgh.pa.us> To: Tom Lane Cc: Alvaro Herrera , pgsql-hackers@postgresql.org, pgsql-patches@postgresql.org Message-id: <4540B8B2.2070800@sun.com> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-2 Content-transfer-encoding: 7BIT References: <453D1B73.2050906@sun.com> <20061023200200.GD11409@alvh.no-ip.org> <27990.1161634170@sss.pgh.pa.us> <453E0A68.4070506@sun.com> <7995.1161697174@sss.pgh.pa.us> User-Agent: Thunderbird 1.5.0.5 (X11/20060911) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.038 tagged_above=0 required=5 tests=AWL, UNPARSEABLE_RELAY X-Spam-Level: X-Archive-Number: 200610/147 X-Sequence-Number: 21471 Tom Lane napsal(a): > Zdenek Kotala writes: >> I prepared patch which use oid output function instead regproc output. >> This change works only for COPY TO command. > > This is not a bug and we're not going to fix it, most especially not > like that. > OK, The behavior of regproc type is described in the documentation, but if we don't fix it, than Some error message like "Regproc data type is not supported by COPY TO command" could be useful. Because you find that something is wrong when you want to restore data back and it should be too late. Zdenek