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

2003-10-08 Thread Tom Lane
Manfred Koizar <[EMAIL PROTECTED]> writes: > Here is a patch that does this and adds a few regression tests. Uh, I did that already ... for 7.4 at least. regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubs

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

2003-10-08 Thread Manfred Koizar
On Sun, 05 Oct 2003 19:12:50 -0400, Tom Lane <[EMAIL PROTECTED]> wrote: >it seems we have to compare the null representation string to the >pre-debackslashing input. Here is a patch that does this and adds a few regression tests. >(This is probably fairly easy to make happen >in CVS tip, but it m

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

2003-10-05 Thread Manfred Koizar
I have solved my restore problem by editing (the relevant part of) the dump (:%s/^IN^I/^IN ^I/), a one-off solution Anyway, thanks for your investigation. On Sun, 05 Oct 2003 19:12:50 -0400, Tom Lane <[EMAIL PROTECTED]> wrote: >it seems we have to compare the null representation string t

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

2003-10-05 Thread Tom Lane
Manfred Koizar <[EMAIL PROTECTED]> writes: > To be clear, this is not about \N as the default external > representation for NULL, I'm talking about a string consisting of the > two characters backslash and uppercase-N. Now that I look at it, this must have been broken since the beginning of time,