Re: [HACKERS] Cannot dump/restore text value \N

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Manfred Koizar <mkoi-pg(at)aon(dot)at>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: [HACKERS] Cannot dump/restore text value \N
Date: 2003-10-08 15:33:24
Message-ID: 200310081533.h98FXON28988@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Manfred Koizar wrote:
> On Wed, 08 Oct 2003 11:31:30 +0200, I wrote:
> >There haven't been too much changes in this area between 7.3 and 7.4.
>
> Here is the patch for 7.3.4 ...
>
> Bruce, I noticed that the original patch submission didn't contain
> anything useful as a cvs log message:
>
> Make COPY FROM a bit more compatible with COPY TO regarding
> backslashes, especially \N.

Oh, good point. Thanks.

Can someone explain what was broken? Was it only for non-standard NULL
strings? Would it silently fail? I saw your example and it seemed
strange we had not seen a bug report before.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff 2003-10-08 15:46:09 Re: Sun performance - Major discovery!
Previous Message Manfred Koizar 2003-10-08 15:24:38 Re: [HACKERS] Cannot dump/restore text value \N

Browse pgsql-patches by date

  From Date Subject
Next Message Peter Eisentraut 2003-10-08 17:44:17 Re: [HACKERS] pg_restore -d doesn't display output
Previous Message Manfred Koizar 2003-10-08 15:24:38 Re: [HACKERS] Cannot dump/restore text value \N