PostgreSQL Table Partitioning + Hibernate

[pahund]

If you want to partition a PostgreSQL database used by a web application based on Hibernate, you may get an exception when inserting a new row into a partitioned table. A typical solution would be to tell Hibernate not to do the result check after the insert operation. But it’s fairly common to introduce table partitioning in a late phase of the project, so you may already have a big project using Hibernate over the whole application. This can make it difficult to find all the places you need to fix. Read on to find out how to use PostgreSQL + Partitioning + Hibernate without touching the application based on Hibernate.