Re: Cannot dump/restore text value \N - Mailing list pgsql-hackers

From Manfred Koizar
Subject Re: Cannot dump/restore text value \N
Date
Msg-id tta1ovgqlae9bqihd2rrrl923k0hbvj8ch@email.aon.at
Whole thread Raw
In response to Re: Cannot dump/restore text value \N  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
I have solved my restore problem by editing (the relevant part of) the
dump (:%s/^I\\\\N^I/^I\\\\N ^I/), a one-off solution <g>

Anyway, thanks for your investigation.

On Sun, 05 Oct 2003 19:12:50 -0400, Tom Lane <tgl@sss.pgh.pa.us>
wrote:
>it seems we have to compare the null representation string to the
>pre-debackslashing input.

Sounds reasonable, IMHO.

>  I wonder whether it would break any existing apps though.

Couldn't be worse than silently converting valid non-null values to
NULL ...

ServusManfred


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Open 7.4 items
Next
From: Bruce Momjian
Date:
Subject: Re: Open 7.4 items