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/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
