This content has been marked as final.
Show 4 replies
-
1. Re: @Lob doesn't clean up large objects on PostgreSQL?
epbernard May 29, 2006 12:31 AM (in response to peter_kaas)so doing delete from MyTable does not delete lobs on postgreSQL?!
Then PostgreSQL needs to be fixed -
2. Re: @Lob doesn't clean up large objects on PostgreSQL?
peter_kaas Jun 2, 2006 5:13 AM (in response to peter_kaas)Ok, this is somewhat older intel, but it is exactly what I am seeing, so I'm assuming it is still true:
http://archives.postgresql.org/pgsql-jdbc/2001-08/msg00129.php
Any chance this can get "fixed" in org.hibernate.dialect.PostgreSQLDialect? Or is there any way in which I can convince ejb3/Hibernate to start doing @Lob as a BYTEA again instead of OID? -
3. Re: @Lob doesn't clean up large objects on PostgreSQL?
supernovasoftware.com Jun 2, 2006 10:56 AM (in response to peter_kaas)I am using the following with PostgreSQL 8.1.3
private byte[] document; public byte[] getDocument() { return document; } public void setDocument(byte[] document) { this.document = document; }
Is the only advantage of @Lob database portability? -
4. Re: @Lob doesn't clean up large objects on PostgreSQL?
peter_kaas Jun 6, 2006 4:32 AM (in response to peter_kaas)Thank you. Removing the @Lob gave me a BYTEA column.