|
Home > Archive > PostgreSQL Administration > January 2006 > upgrade help
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Josh O'Brien 2006-01-12, 9:24 am |
| 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
| |
| Tom Lane 2006-01-12, 1:23 pm |
| "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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
| |
| Michael Fuhr 2006-01-12, 1:23 pm |
| 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
|
|
|
|
|