Re: restore whoes

Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > I just think forcing the escape of \r isn't reasonable.
>
> It's not ideal, certainly, but I think it's preferable to continuing
> to get burned every time a pg_dump file comes within hailing distance
> of Windoze.  We've seen these complaints over and over, and we'll
> continue to see them again and again until we do something to become
> proof against the problem.  There is no solution that doesn't involve
> some amount of backwards-incompatibility.  So let's bite the bullet and
> do it.  We can offer a GUC switch to provide the old COPY IN behavior
> for people who need it --- but given the shape of the world today, the
> default behavior needs to be Microsoft-proof.

I am afraid we will fix the \r\n problem but cause many more problems
with old dumps and hand-created COPY files.

What if we add GUC param and keep the behavior unchanged?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026