From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
Cc: | pgsql-hackers-win32(at)postgresql(dot)org |
Subject: | Re: Re : Win32 binaries test / pg_dump problem |
Date: | 2004-05-28 18:34:51 |
Message-ID: | 200405281834.i4SIYpl01115@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers-win32 pgsql-patches |
Andrew Dunstan wrote:
> 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
> > or
> >> > 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
> > for
> > 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
> > crash
> > on copy to) though.
> >
> > do you known where this modification needs to be done ?
> >
> > cyril
> >
>
> probably in src/bin/psql/command.c::process_file()
>
> instead of mode "r" we should probably use the predefined constant
> PG_BINARY_R
Uh, but it isn't a binary file, it is SQL commands.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2004-05-28 18:52:04 | Re: Re : Win32 binaries test / pg_dump problem |
Previous Message | Cyril VELTER | 2004-05-28 17:09:41 | Re: Re : Win32 binaries test / pg_dump problem |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2004-05-28 18:37:14 | Re: thread safety testing fix |
Previous Message | Bruce Momjian | 2004-05-28 18:32:58 | Re: Link errors on win32 |