invalid input syntax for type bytea - Mailing list pgsql-general

From Janning Vygen
Subject invalid input syntax for type bytea
Date
Msg-id 200504041658.02543.vygen@gmx.de
Whole thread Raw
Responses Re: invalid input syntax for type bytea  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi,

i have a databse in postgresql 7.4 with some pdf files in a bytea column.

everything works fine but sometimes when i dump and restore i get

psql:../tmp/dump.sql:704022: ERROR:  invalid input syntax for type bytea
CONTEXT:  COPY dk_dokument, line 127, column dk_content:
"%PDF-1.4\015%\342\343\317\323\015\01220 0 obj\015<< \015/Linearized 1
\015/O 22 \015/H [ 660 209 ] \..."

how can things like this happen? Is it a problem with COPY command?

I guess my input into bytea must be ok otherwise postgresql should report an
error on insert statmenet, shouldn't it?

kind regards,
janning

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Vacuum time degrading
Next
From: Martijn van Oosterhout
Date:
Subject: Re: How to query pgsql from a BASH script ?