Hi Dominique, >ERROR: literal carriage return found in data >HINT: Use "\r" to represent carriage return. >CONTEXT: COPY netjuke_tracks, line 3312: "3196 940 335 4 >21 Things I Want In A Lover 4991999 >207 1 2002 2003-05-16 21:24:08+02 192 44100 >MPEG ..." > >"phpbb_posts_text" and "netjuke_tracks" don't have no rows anymore which >is pretty bad. I had a look at the backup-file, the data is still >there. Do I have any chance to recover the data? Perhaps by >manipulating the backup file?
Sounds like a problem I had a week or two ago that I posted to the novice list. Here's a link to how I got it resolved. http://archives.postgresql.org/pgsql-novice/2003-11/msg00158.php HTH, -b ---------------------------(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
