470,647 Members | 1,155 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,647 developers. It's quick & easy.

bytea SQL ERROR with size

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
1 3224
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.

Similar topics

reply views Thread by mPath Records | last post: by
48 posts views Thread by Edwin Quijada | last post: by
2 posts views Thread by Alvar Freude | last post: by
4 posts views Thread by David Garamond | last post: by
6 posts views Thread by Egyd Csaba | last post: by
1 post views Thread by Jerry LeVan | last post: by
4 posts views Thread by Egyd Csaba | last post: by
1 post views Thread by George Sakkis | last post: by
reply views Thread by warner | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.