Re: ByteA for binary data? - Mailing list pgsql-general

From Doug McNaught
Subject Re: ByteA for binary data?
Date
Msg-id m3g03q1d1f.fsf@varsoon.denali.to
Whole thread Raw
In response to ByteA for binary data?  (Robert Myers <ccrider@whiterose.net>)
Responses Re: ByteA for binary data?  (Robert Myers <ccrider@whiterose.net>)
List pgsql-general
Robert Myers <ccrider@whiterose.net> writes:

> I've read the available documentation on LO and bytea, and both seem to
> have troubles, is this something that will be fixed in a future
> release?  I'm currently running 7.2.

I've been using LOs with great success since 7.1--there are no current
problems with it, though the API is a little convoluted.  I prefer
them to bytea fields becauser you're not forced to load the whole
thing into memory either on the server or client side (I work with
multi-megabyte data files).  I use Java on the client.

Have you read the bytea docs on proper quoting?  Is your PHP install
up to date?  Older versions would truncate queries at 8k I think...

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Nice Oracle tuning article
Next
From: "Thomas T. Thai"
Date:
Subject: Re: ByteA for binary data?