From: | Janning Vygen <vygen(at)planwerk6(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | invalid input syntax for type bytea |
Date: | 2005-04-04 14:54:46 |
Message-ID: | 200504041654.46634.vygen@planwerk6.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
--
PLANWERK 6 websolutions
Herzogstraße 85, 40215 Düsseldorf
Tel.: 0211-6015919 Fax: 0211-6015917
http://www.planwerk6.de/
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2005-04-04 14:56:06 | Re: How to query pgsql from a BASH script ? |
Previous Message | Tom Lane | 2005-04-04 14:50:25 | Re: Vacuum time degrading |