Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:3.2

Name and version of the database you are using:Postgresql 8.1

I have created a table in which I have a field of type BLOB which I store pictures. I insert a picture, note the oid generated. Then I do the following select statement on table 'pg_largeobject' (system table) : select * from pg_largeobject where loid = 'oid of my picture'. I found the oid.
Then I update my picture. Its oid has been changed. I now make another select from table 'pg_largeobject' where loid = 'my OLD oid' and I was surprised to see that the old oid is STILL in the table. So I conclude that each time I update a picture from my table. The old oids are still there and eventually my database is increasing in size.

Is this not a bug in hibernate?

thanks in advance
Read this: http://hibernate.org/42.html