Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 92A4E475BC3 for ; Wed, 22 Jan 2003 07:42:49 -0500 (EST) Received: from pxdcms01.psynapsetech.net (unknown [208.246.69.99]) by postgresql.org (Postfix) with ESMTP id E0C564759AF for ; Wed, 22 Jan 2003 07:42:48 -0500 (EST) Received: from psynapsetech.net ([208.246.69.118]) by pxdcms01.psynapsetech.net (8.11.6/8.11.6) with ESMTP id h0MCKqV20789; Wed, 22 Jan 2003 07:20:52 -0500 Message-ID: <3E2E9164.1080201@psynapsetech.net> Date: Wed, 22 Jan 2003 07:41:08 -0500 From: john guthrie User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.2.1) Gecko/20021130 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: pgsql-interfaces@postgresql.org Subject: Re: problem with 'copy binary' file format References: <3E2DB3A2.7020503@psynapsetech.net> <13049.1043187541@sss.pgh.pa.us> In-Reply-To: <13049.1043187541@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/90 X-Sequence-Number: 3590 i agree. i'm not doing anything with the file. i can start up psql, type: copy binary my_table from 'tmpfile'; and get the exact same error message. the table schema, by the way, consists of two int4's, a timestamp, and a bytea. thanks. john Tom Lane wrote: > john guthrie writes: > >>i am having a problem creating a 'copy binary' input file in c >>on my linux box running postgresql 7.2.2. the error message i get is: >> ERROR: copy: line 1, pg_atoi: error in "PGBCOPY": can't parse "PGBCOPY" > > > And what exactly are you doing with the file after you create it? > pg_atoi shouldn't be invoked at all during COPY BINARY FROM ... > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)