> If you put the column as last in your schema.xml file it should be the
> last
> column in the insert statement.  I could easily be wrong on that though

Sometimes it works--I did generate a table that worked, but it only had 
two columns (id, data).  I tried it with several more columns and it didn't.

I think the take-home lesson here is, large objects are not very 
portable, and you should try to isolate them by themselves to the 
greatest extent possible.

I think part of point of OID and BLOB, etc., vs BYTEA and LONG RAW, is 
to make this isolation implicit, 'cause they both store only object 
locator or id in the table itself and store the object contents 
somewhere else.  But, as you point out, this hiding complicates working 
with JDBC.

-- Bill


--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Reply via email to