Hibernate version:
Hibernate 3 RC1

Name and version of the database you are using:
PostgreSQL 8

org.hibernate.dialect.PostgreSQLDialect returns "oid" for Types.BLOB. According to the PostgreSQL docs, OID types are used internally by PostgreSQL as primary keys. It should return "bytea" as net.sf.hibernate.dialect.PostgreSQLDialect does... I'll log a Jira issue...

This issue seems to indicate that it should be working but the source still returns "oid". It was working in Hibernate 2.x and I don't really follow the reason for the change to "oid" change.

This is made evident by using the org.hibernate.tool.hbm2ddl.SchemaExport class. The generated DDL contains columns with a type of OID that should (I think) be "bytea".

Both are valid for postgresql BLOBS, http://www.postgresql.org/files/documen ... ode96.html

Interesting... when I use the column type "bytea" everything works fine, if I change it to "oid" i get the following error...

15:24:45.976 [WARN] [org.hibernate.util.JDBCExceptionReporter] - SQL Error: 0, SQLState: 22P02
15:24:45.976 [ERROR] [org.hibernate.util.JDBCExceptionReporter] - ERROR: invalid input syntax for type oid:...

Maybe it doesn't work with PostgreSQL 8...

If I follow the instructions mentioned on the castor page and add "compatible=7.1" to my jdbc connection URL the OID stuff works... that doesn't seem right to me... Maybe the current PostgeSQL dialect hasn't been tested with PostgreSQL 8.x?

I take it all back. Nothing wrong with BLOBs using Hibernate3 and PostgreSQL...