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.
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 |