X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3482FDA736 for ; Thu, 22 Sep 2005 10:27:01 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 58304-09 for ; Thu, 22 Sep 2005 13:26:55 +0000 (GMT) Received: from hotmail.com (bay108-f3.bay108.hotmail.com [65.54.162.13]) by svr1.postgresql.org (Postfix) with ESMTP id CCB6BDA72F for ; Thu, 22 Sep 2005 10:26:56 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 22 Sep 2005 06:27:00 -0700 Message-ID: Received: from 65.54.162.200 by by108fd.bay108.hotmail.msn.com with HTTP; Thu, 22 Sep 2005 13:27:00 GMT X-Originating-IP: [207.236.65.226] X-Originating-Email: [kevinrkeith@hotmail.com] X-Sender: kevinrkeith@hotmail.com From: "Kevin Keith" To: pgsql-admin@postgresql.org Subject: Copy command not writing complete data to text file Date: Thu, 22 Sep 2005 08:27:00 -0500 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 22 Sep 2005 13:27:00.0378 (UTC) FILETIME=[4FFBD7A0:01C5BF79] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=3.144 required=5 tests=[AWL=-0.437, DNS_FROM_RFC_ABUSE=0.374, DNS_FROM_RFC_POST=1.376, MSGID_FROM_MTA_HEADER=0, RCVD_IN_BL_SPAMCOP_NET=1.832] X-Spam-Level: *** X-Archive-Number: 200509/232 X-Sequence-Number: 18969 I am having some problems with the COPY... to FILE command - and I am wondering if anyone has experienced similar problems in the past, and what you may have done to resolve the problem? The platform is Free BSD, Postgres version 7.4.5 and the program triggering the COPY command is a CGI script. I am copying out to a text files using PQexec - there are no more than 500 records in the tables being copied. What is happening, is one instance of the COPY command is always stopping after dumping 16,384 bytes (16K) to the text file - the last record is always truncated (i.e. the if the table has 20 columns, the last record may only have 7 columns in the flat file). There is also no error returned in the program - to the program calling the copy command everything gives an appearance of working. What makes this problem difficult to resolve is that if I run the exact same COPY command from the PSQL prompt, everything works with no problems. Disk space is not an issue - there is sufficient memory to store the text files many times over. Has anyone else experienced similar issues, or can you point me to something that may be causing this behavior to occur? Thanks, Kevin _________________________________________________________________ FREE pop-up blocking with the new MSN Toolbar – get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/