Re: [Oledb-dev] [HACKERS] Re: double precision error with pg linux server, but not with windows pg server

2007-05-19 Thread Shachar Shemesh
Tom Lane wrote: Obviously, if you are transporting the dump across platforms then that may be an impossibility. In that case you use a text dump and accept that you get an approximation. ‎That's something that I've been meaning to ask about, but you all seemed so sure of yourself. What you are

Re: [Oledb-dev] [HACKERS] Re: double precision error with pg linux server, but not with windows pg server

2007-05-19 Thread Shachar Shemesh
Andrew Dunstan wrote: Why the heck do the OLE DB specs care about the internals of the client-server prototocol? It is documented fairly clearly that text is the only portable way to transfer data. Is it? Perhaps we need to expand this sentence in the docs: Keep in mind that binary

Re: [Oledb-dev] [HACKERS] Re: double precision error with pg linux server, but not with windows pg server

2007-05-19 Thread Andrew Dunstan
Shachar Shemesh wrote: Even the original sentence does not describe the problem we're seeing here. It does not mention cross platform incompatibility. That's why I suggested it should be improved. The COPY docs are probably more correct: The BINARY key word causes all data to be