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:39:58
Message-ID: F237YHkidcDjoYAPNXR000029a3@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.

_________________________________________________________________
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephan Szabo 2002-03-27 18:40:43 Re: RI triggers and schemas
Previous Message Matias Klein 2002-03-27 18:30:35 escape sequence conflicting w/ backup (i.e. pg_dump)