The problem is that you can't stream the data into a bytea, now I can't remember why. Otherwise, Postgres team recomends to use the pg_largeobject table to keep the integrity of your data.
On Thu, Sep 4, 2008 at 12:27 PM, Ognjen Blagojevic <[EMAIL PROTECTED]>wrote: > Ok, I altered the Image table as you proposed (BYTEA -> INTEGER), and now > it works just fine. Thank you. > > There should be a note in the "Streaming LOB support" documentation, > explaining how to use it with PostgreSQL DB. > > BTW, what is the problem with streaming and BYTEA columns? Using > pg_largeobject instead of bytea might be an expensive trade-off. > > Regards, > Ognjen > > > Ignacio Andreu wrote: > >> Hi, >> >> I've check the code and your e-mails, you said that you have the column as >> bytea, with the lastest code in the trunk your column must be an integer, >> OpenJPA uses it to reference the id in the pg_largeobject table. Please, >> can >> you alter this and try to run your case? >> >
