What should I use instead of PostgreSQL11Dialect?

Question

I am using Hibernate 5 and PostgreSQL 11. I checked dialects and the latest is PostgreSQL95Dialect.

What should I use with a newer version of the database I have?

I assume that there is no major problem using PostgreSQL95Dialect but it sounds wrong for me, especially database may further upgrade and the closer versions can be updated more seamlessly in the future.

Reason:

The reason, I care about dialects, I want to introduce new type jsonb which is not supported by Hibernate, so I want to be as close to the contemporary version of a DB as possible, dialect-wise as well.

Karol Dowbecki · Accepted Answer · 2020-01-28 13:07:30Z

4

If you plan to use PostgreSQL 11 features you probably should implement the dialect yourself.

In Hibernate 6.0 new PostgreSQL10Dialect was introduced. When implementing your own PostgreSQL11Dialect you probably want to follow the same approach, which is extending PostgreSQL95Dialect and adding features you need.

answered Jan 28, 2020 at 13:07

Karol Dowbecki

45.3k9 gold badges83 silver badges118 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Seva Golovanov Over a year ago

Meh, 10 just adds identity columns. The PG dialects are still missing tons of stuff like ts functions etc...

dcalap · Accepted Answer · 2020-01-28 13:12:21Z

2

Latest in the official hibernate GitHub repository is PostgreSQL10Dialect. However, this one is still not referenced in the latest official documentation.

answered Jan 28, 2020 at 13:12

dcalap

1,0723 gold badges15 silver badges39 bronze badges

Collectives™ on Stack Overflow

What should I use instead of PostgreSQL11Dialect?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related