Thread: upgrade help

upgrade help

From
Josh O'Brien
Date:
Hello all,

I am upgrading from postgresql version 7.4 to 8.1 and i'm having a
problem with pg_restore.  It is not recognizing the \N command as
inserting a null value.  Does anyone know how to fix this?
Thanks in advance

Attachment

Re: upgrade help

From
Tom Lane
Date:
"Josh O'Brien" <obrien@zedxinc.com> writes:
> I am upgrading from postgresql version 7.4 to 8.1 and i'm having a
> problem with pg_restore.  It is not recognizing the \N command as
> inserting a null value.

Doesn't seem very likely.  What exactly did you do, and what results
are you getting?

            regards, tom lane

Re: upgrade help

From
Michael Fuhr
Date:
On Thu, Jan 12, 2006 at 09:15:08AM -0500, Josh O'Brien wrote:
> I am upgrading from postgresql version 7.4 to 8.1 and i'm having a
> problem with pg_restore.  It is not recognizing the \N command as
> inserting a null value.  Does anyone know how to fix this?

Please post the exact commands you ran and the exact error messages
or undesired behavior you're seeing.  Be sure to mention the client
and server versions for each command (e.g., 8.1.2 pg_dump connecting
to 7.4.11 server, and so on).

--
Michael Fuhr