Re: Import from Linux to Windows

I don't think so. Did a search for it in vi and nothing. It doesn't give
me an error, just exits. Last statement is "CREATE TABLE". 

Sorry, not very helpful...

Thanks, Tom

-----Original Message-----
From: Andrew Dunstan [mailto:[email protected]] 
Sent: Wednesday, August 11, 2004 1:44 PM
To: Tom Haddon
Cc: [email protected]
Subject: Re: [pgsql-hackers-win32] Import from Linux to Windows




Tom Haddon wrote:

>Hi,
>
>I have a dump file created using pg_dumpall on Linux that I'm trying to

>import into Windows. I know this dump file is good as I've tested it 
>and looked at it. When I run it against the Windows version 
>(8.0.0beta1) from within psql with the \i switch, it loads in the 
>structure of the first database in the dump, and creates all the 
>databases and users, but doesn't populate the data of the first 
>database, and doesn't create the structure of all the other databases.
>
>My guess is this is a Windows formatting issue. Do I just need to do a 
>search and replace on \n or \t and replace it with something?
>
>
>  
>

What is the error? You don't by any chance have a ^Z somewhere in the 
file, do you?

cheers

andrew

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match