escape sequence conflicting w/ backup (i.e. pg_dump)

From: "Matias Klein" <matiasklein(at)hotmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: escape sequence conflicting w/ backup (i.e. pg_dump)
Date: 2002-03-27 18:30:35
Message-ID: F251Pjea2LWkdkTQUM600002953@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I have a postgresql DB that contains a lot of HTML code. As you know, HTML
contains numerous backslash( \ ) characters. When I use pg_dump to backup
the DB I get a "CopyReadAttribute: end of record marker corrupted" error.
Is there any way to circumvent this problem so that I can backup a DB with
HTML code stored in it?

Thanks,
Matias

>CopyReadAttribute: end of record marker corrupted
>
>This message comes out if the COPY data contains \. not immediately
>followed by newline (\n). I'm guessing that you have some backslashes
>that need to be doubled --- backslash is an escape character for COPY.

_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com

Browse pgsql-hackers by date

  From Date Subject
Next Message Matias Klein 2002-03-27 18:39:58 escape sequence conflicting w/ backup (i.e. pg_dump)
Previous Message Tom Lane 2002-03-27 17:26:48 Re: Rough sketch for locale by default