Message-ID: <3E2DB3A2.7020503@psynapsetech.net>
Date: Tue, 21 Jan 2003 15:54:58 -0500
From: john guthrie <jguthrie@psynapsetech.net>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.2.1) Gecko/20021130
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: problem with 'copy binary' file format
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

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"

so it looks to me like the header doesn't match what it should. my
code creates/writes the header like this:

     char *bchead = "PGBCOPY\n\377\r\n\0";
     unsigned int bcsig = 0x01020304;
     unsigned int bcflags = 0x0;
     unsigned int bcext = 0x0;

     outFile = fopen(tmpfile, "w");
     fwrite(bchead,1,12,outFile);
     fwrite(&bcsig,1,4,outFile);
     fwrite(&bcflags,1,4,outFile);
     fwrite(&bcext,1,4,outFile);

when i 'od -c' the created file, i see:
local jguthrie> od -c /tmp/packets.bin
0000000   P  G  B  C  O  P  Y \n 377 \r  \n  \0 004 003 002 001
0000020  \0 \0 \0 \0 \0 \0 \0 \0 004 \0 377 377
0000034

(this for a 4-field tuple with no rows in the data file).

this all seems to match up with the documentation online:
  http://www.postgresql.org/idocs/index.php?sql-copy.html

any help much appreciated.

thanks. john.