| From: | Manfred Koizar <mkoi-pg(at)aon(dot)at> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Cannot dump/restore text value \N |
| Date: | 2003-10-06 00:01:04 |
| Message-ID: | tta1ovgqlae9bqihd2rrrl923k0hbvj8ch@email.aon.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
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(at)sss(dot)pgh(dot)pa(dot)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 ...
Servus
Manfred
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-10-06 00:12:49 | Re: Open 7.4 items |
| Previous Message | Tom Lane | 2003-10-05 23:58:14 | Re: Open 7.4 items |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-10-06 00:12:49 | Re: Open 7.4 items |
| Previous Message | Tom Lane | 2003-10-05 23:58:14 | Re: Open 7.4 items |