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

Поиск
Список
Период
Сортировка
От Lou Duchez
Тема BUG #3795: pg_dump is mis-dumping columns containing line breaks
Дата
Msg-id 200712022001.lB2K1fZ3015321@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #3795: pg_dump is mis-dumping columns containing line breaks  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      3795
Logged by:          Lou Duchez
Email address:      lou@paprikash.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.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: NikhilS
Дата:
Сообщение: Re: [HACKERS] BUG #3774: create table like including index doesn't update pg_constraints with primary key
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #3795: pg_dump is mis-dumping columns containing line breaks