info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
bytea SQL ERROR with size
0 views
Skip to first unread message
lionel pacoud
Jun 11, 2004, 4:22:07 AM6/11/04
to
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).getLargeObjectAPI();
Conclusion, I really need help. I don't see any solutions.
well, thanks for your help.
lionel
lionel pacoud
Jun 15, 2004, 10:42:17 AM6/15/04
to
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.
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.
0 new messages