Cyril VELTER said:
> From: "Andrew Dunstan" <andrew(at)dunslane(dot)net>
>> Cyril VELTER wrote:
>> > if you psql -f test.sql basetest from the windows shell to a
>> > windows
>> > linux database, you'll get a missing data error :
>> > psql:test.sql:9: ERROR: missing data for column "b"
>> > CONTEXT: COPY test, line 1: "a"
>> > if you psql -f test.sql basetest from a linux shell to a windows
>> > or
>> > linux database, you won't get an error
>> Sounds like we should have psql open the file in binary mode on
>> Windows. Would that cause problems? I doubt it, but I wonder.
> you might be right, I just found some information on msdn that fseek
> example is influenced by ctrl-z when the file is opened in text mode.
> I'm not sure that this is the cause of the second problem (backend
> on copy to) though.
> do you known where this modification needs to be done ?
probably in src/bin/psql/command.c::process_file()
instead of mode "r" we should probably use the predefined constant
In response to
pgsql-patches by date
|Next:||From: Rory Campbell-Lange||Date: 2004-05-28 11:22:47|
|Subject: pg_dump and schema namespace notes|
|Previous:||From: Harald Fuchs||Date: 2004-05-28 10:55:59|
|Subject: Re: pg_dump --comment?|
pgsql-hackers-win32 by date
|Next:||From: Andreas Pflug||Date: 2004-05-28 12:00:18|
|Subject: Compiling libpq with VisualC|
|Previous:||From: Cyril VELTER||Date: 2004-05-28 10:18:57|
|Subject: Re: Re : Win32 binaries test / pg_dump problem|