Skip site navigation (1) Skip section navigation (2)

Re: problems transfering databases

From: "Rob Arnold" <rob(at)cabrion(dot)com>
To: "Miroslav Koncar" <miroslav(dot)koncar(at)etk(dot)ericsson(dot)se>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: problems transfering databases
Date: 2001-08-24 23:12:07
Message-ID: 001601c12cf2$43036bd0$ (view raw, whole thread or download thread mbox)
Lists: pgsql-generalpgsql-odbc
Have him dump the table again (if he can) using pg_dump's "proper inserts" switch turned on.  Tom, I'm not contradicting that the problem may be directly linked to CR's in the data.  I have encountered this before and I worked around it with proper inserts.  I was working in Linux and never transferred the file anywhere.


  ----- Original Message ----- 
  From: Miroslav Koncar 
  To: Tom Lane 
  Cc: pgsql-general(at)postgresql(dot)org 
  Sent: Friday, August 24, 2001 2:23 AM
  Subject: Re: problems transfering databases

  Hello, Tom, 
  nope, no windows here. The file was sent direclty from the Linux to my mailbox, which I read on Solaris. 

  The only thing I can think of is the PostgreSQL versions. My collegue is using 7.0.3, and I use 7.1.2. Comments? 


  Tom Lane wrote: 

    Miroslav Koncar <miroslav(dot)koncar(at)etk(dot)ericsson(dot)se> writes: 
    > Since it is a simple test database, the 2001-06-04db.out file was around 
    > 40kB, so he has sent it to me via email. 
    Email huh?  I bet some part of that process was Windows?  Almost 
    certainly that's where the carriage return characters came from. 

                            regards, tom lane

Miroslav Koncar
Software Engineer
Ericsson Nikola Tesla
Tel: +385 1 365 3479
Fax: +385 1 365 3548

In response to

pgsql-odbc by date

Next:From: Johann ZuschlagDate: 2001-08-26 18:51:25
Subject: Again, it doesn't compile :-)
Previous:From: Peter EisentrautDate: 2001-08-24 22:56:59
Subject: RE: ODBC include files

pgsql-general by date

Next:From: Peter EisentrautDate: 2001-08-25 00:45:40
Subject: Re: Permissions for large-object comments
Previous:From: uncleleoDate: 2001-08-24 21:53:00
Subject: !! Newbie question!!!! connecting to multiple databases

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group