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 representations for complex data types may change across server > versions;" > Where is that in the docs. It does not appear in the page discussing PQLIB and binary data transfers (http://www.postgresql.org/docs/8.2/interactive/libpq-exec.html).
Even the original sentence does not describe the problem we're seeing here. It does not mention cross platform incompatibility. > The COPY docs are probably more correct: "The BINARY key word causes all > data to be stored/read as binary format rather than as text. It is > somewhat faster than the normal text mode, but a binary-format file is > less portable across machine architectures and PostgreSQL versions." > Again, to me this sentence spells "you have a problem, we're not going to help you out, deal with it". This is especially true if what Tom said was true, that the text format does not maintain total precision. You are essentially telling the user "you cannot move your data reliably even between servers of the same version". Shachar ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org