[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2244) Problem with data type 'Blob'

[Max Rydahl Andersen (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2244?page=comments#action_25320 ] 

Max Rydahl Andersen commented on HHH-2244:
------------------------------------------

so install a trigger in postgressql to delete the corresponding blob or have the blob mapped as an entity ? 

>From what I understand postgress doesn't diretly support jdbc's assumption that a blog is "part of" the row, which means jdbc assumes the blog goes away when the row is deleted but posgressql keeps the blob around since it could be shared by others.



> Problem with data type 'Blob'
> -----------------------------
>
>          Key: HHH-2244
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2244
>      Project: Hibernate3
>         Type: Bug

>  Environment: Hibernate version:3.2
> DB: postgresql 8.1
>     Reporter: Gulshanrai BABAJEE

>
>
> 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 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira