Support Lob in Postgres

[DavideD]

Postgres Vert.x SQL client doesn't seem to support the OID type. See https://github.com/eclipse-vertx/vertx-sql-client/issues/1328

Marking this as regression, because it used to work before the Upgrade to ORM 6.2

[dkostakev]

Is there any clarity when the LOB is going to be supported in Postgres?

[gavinking]

Is there any clarity when the LOB is going to be supported in Postgres?

There is no BLOB or CLOB type in Postgres so you need to be much more specific about what you mean by this.

• If you mean OID, then no, that depends on support from the Vert.x driver, as noted in the linked issue.
• If you mean BYTEA, which you almost certainly do, then that is already supported and has been for a very long time.

Of course, you should follow the advice in the Hibernate documentation and not use the useless @Lob annotation when mapping BYTEA columns:

https://docs.jboss.org/hibernate/orm/6.5/introduction/html_single/Hibernate_Introduction.html#lobs