Re: Problem with the pg_dumpall file format - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Problem with the pg_dumpall file format
Date
Msg-id 10721.1224427294@sss.pgh.pa.us
Whole thread Raw
In response to Problem with the pg_dumpall file format  (Martin Gregorie <martin@gregorie.org>)
List pgsql-bugs
Martin Gregorie <martin@gregorie.org> writes:
> For some reason, when my message table (see below) is dumped, blank
> lines are introduced between rows.

Nothing like that has been reported before.  We have heard of dump files
getting corrupted after they've been produced --- the most common case
is newlines (\n) getting converted to carriage-return-line-feed (\r\n)
due to being copied onto a Windows machine.  The COPY data format is
reasonably impervious to that, but I suppose it's possible that a second
conversion step might incorrectly change \r\n to \n\n.

If you're certain that nothing is happening to the dump file after the
fact, then we'll need to see a self-contained test case.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Martin Gregorie
Date:
Subject: Problem with the pg_dumpall file format
Next
From: Magnus Hagander
Date:
Subject: Re: BUG #4455: Valid SSL certificate reported as expired