problem with 'copy binary' file format

Поиск
Список
Период
Сортировка
От john guthrie
Тема problem with 'copy binary' file format
Дата
Msg-id 3E2DB3A2.7020503@psynapsetech.net
обсуждение исходный текст
Ответы Re: problem with 'copy binary' file format
Re: problem with 'copy binary' file format
Список pgsql-interfaces
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;
unsignedint 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.



В списке pgsql-interfaces по дате отправления:

Предыдущее
От: Michiel Lange
Дата:
Сообщение: Re: Problems compiling with libpq
Следующее
От: Tom Lane
Дата:
Сообщение: Re: problem with 'copy binary' file format