BUG #3795: pg_dump is mis-dumping columns containing line breaks

From: "Lou Duchez" <lou(at)paprikash(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3795: pg_dump is mis-dumping columns containing line breaks
Date: 2007-12-02 20:01:41
Message-ID: 200712022001.lB2K1fZ3015321@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 3795
Logged by: Lou Duchez
Email address: lou(at)paprikash(dot)com
PostgreSQL version: 8.3 beta 3
Operating system: Windows 2003
Description: pg_dump is mis-dumping columns containing line breaks
Details:

Hello,

My copy of PostgreSQL has standard_conforming_strings set to "on", and when
I attempt to pg_dump tables that have strings containing CR/LFs, the data
dumps in a format that psql cannot then reload. The CR/LFs are preceded by
a backslash ("\") in the dump but are not themselves "escaped" -- so instead
of looking like this:

line 1\nline2\nline3

it looks like this:

line 1\
line 2\
line 3

And psql seems to be unable to handle data in that format.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2007-12-02 21:29:54 Re: BUG #3795: pg_dump is mis-dumping columns containing line breaks
Previous Message NikhilS 2007-12-02 08:14:20 Re: [HACKERS] BUG #3774: create table like including index doesn't update pg_constraints with primary key