By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,302 Members | 1,299 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,302 IT Pros & Developers. It's quick & easy.

bytea SQL ERROR with size

P: n/a
Hi,

ok, so I have pictures that I store in Postgres (7.2.4) via JDBC.
if the size of my picture is small (less than 1ko) it's ok, there is
no pb.
but I never succed to put a bigger picture.
the response is :
java.sql.SQLException: ERROR: index_formtuple: data takes 211980
bytes, max is 8191... or
java.sql.SQLException: ERROR: btree: index item size 2768 exceeds
maximum 2713...

it depends of the size of the picture...

I tried to use Large Object instead of bytea but, there is a
ClassCastException when I do this :
LargeObjectManager lobj =
((org.postgresql.Connection)conn).getLargeObjectAP I();

Conclusion, I really need help. I don't see any solutions.

well, thanks for your help.
lionel
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
Ok,
so i found a solultion (maybe it could help someone else):
it seems that postgres doesn't accept unique constraint on bytea of
size bigger than 1ko
if I remove the unique constraint, it's OK.
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.