pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
upgrade help
3+ messages / 3 participants
[nested] [flat]

* upgrade help
@ 2006-01-12 14:15 Josh O'Brien <obrien@zedxinc.com>
  2006-01-12 17:28 ` Re: upgrade help Tom Lane <tgl@sss.pgh.pa.us>
  2006-01-12 17:30 ` Re: upgrade help Michael Fuhr <mike@fuhr.org>
  0 siblings, 2 replies; 3+ messages in thread

From: Josh O'Brien @ 2006-01-12 14:15 UTC (permalink / raw)
  To: pgsql-admin

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

Attachments:

obrien.vcf (text/x-vcard, 111B) download begin:vcard fn:Joshua O'Brien n:O'Brien;Joshua org:Zedx Inc. title:Database Administrator version:2.1 end:vcard
^ permalink raw reply [nested|flat] 3+ messages in thread

* Re: upgrade help
  2006-01-12 14:15 upgrade help Josh O'Brien <obrien@zedxinc.com>
@ 2006-01-12 17:28 ` Tom Lane <tgl@sss.pgh.pa.us>
  1 sibling, 0 replies; 3+ messages in thread

From: Tom Lane @ 2006-01-12 17:28 UTC (permalink / raw)
  To: Josh O'Brien <obrien@zedxinc.com>; +Cc: pgsql-admin

"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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: upgrade help
  2006-01-12 14:15 upgrade help Josh O'Brien <obrien@zedxinc.com>
@ 2006-01-12 17:30 ` Michael Fuhr <mike@fuhr.org>
  1 sibling, 0 replies; 3+ messages in thread

From: Michael Fuhr @ 2006-01-12 17:30 UTC (permalink / raw)
  To: Josh O'Brien <obrien@zedxinc.com>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2006-01-12 17:30 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-01-12 14:15 upgrade help Josh O'Brien <obrien@zedxinc.com>
2006-01-12 17:28 ` Tom Lane <tgl@sss.pgh.pa.us>
2006-01-12 17:30 ` Michael Fuhr <mike@fuhr.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox