Re: [BUGS] BUG #3795: pg_dump is mis-dumping columns containing line breaks

2007-12-03 Thread Jorge Godoy
Em Sunday 02 December 2007 21:24:09 Tom Lane escreveu: > [EMAIL PROTECTED] writes: > > The two versions of PostgreSQL produce slightly different results. > > Yeah, that's an intentional change. > > > The 8.3 version, with the unescaped line breaks, confuses the heck out > > of psql. > > Works fine

Re: [BUGS] BUG #3795: pg_dump is mis-dumping columns containing line breaks

2007-12-02 Thread Tom Lane
I wrote: > Maybe your test case involves letting Windows mangle the line endings? On reflection, I'm sure that's exactly what's happening. I now remember that one of the reasons for the old dump behavior was to make COPY data a bit safer against line-ending mangling. I've reverted this rather il

Re: [BUGS] BUG #3795: pg_dump is mis-dumping columns containing line breaks

2007-12-02 Thread Tom Lane
[EMAIL PROTECTED] writes: > The two versions of PostgreSQL produce slightly different results. Yeah, that's an intentional change. > The 8.3 version, with the unescaped line breaks, confuses the heck out > of psql. Works fine for me --- I can load either dump file into either version of psql. M

Re: [BUGS] BUG #3795: pg_dump is mis-dumping columns containing line breaks

2007-12-02 Thread lou
> "Lou Duchez" <[EMAIL PROTECTED]> writes: > > 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. > > It works fine here. Please provide a *co

Re: [BUGS] BUG #3795: pg_dump is mis-dumping columns containing line breaks

2007-12-02 Thread Tom Lane
"Lou Duchez" <[EMAIL PROTECTED]> writes: > 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. It works fine here. Please provide a *complete* exam

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

2007-12-02 Thread Lou Duchez
The following bug has been logged online: Bug reference: 3795 Logged by: Lou Duchez Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3 beta 3 Operating system: Windows 2003 Description:pg_dump is mis-dumping columns containing line breaks Details: Hello, My c