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
