[GENERAL] Re: problems transfering databases

2001-08-24 Thread Rob Arnold
I never transfered the file anywhere, it was all done under linux. The bottom line is pg_dump follwed by a psql import failed exactly like what was described in this thread. When I did a dump with "proper inserts" it worked fine. As I said, I don't know what was causing the problem, just th

[GENERAL] Re: problems transfering databases

2001-08-24 Thread Jeff Eckermann
I very much doubt that the data wouldn't "dump right".  The dump will include any data that is in the table, including CRs if they are in there. In the current case, the CRs were not already in there, because PostgreSQL would not have recognized that field as null ("\N") if they were. Any tr