Re: Cannot dump/restore text value \N

Поиск
Список
Период
Сортировка
От Manfred Koizar
Тема Re: Cannot dump/restore text value \N
Дата
Msg-id tta1ovgqlae9bqihd2rrrl923k0hbvj8ch@email.aon.at
обсуждение исходный текст
Ответ на Re: Cannot dump/restore text value \N  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Open 7.4 items
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Open 7.4 items