Re: Postgres Partitions not working with hibernate 4.1.6.Final

On Tue, Sep 25, 2012 at 3:12 PM, Freddie Burgess
<fburgess@radiantblue.com> wrote:
>
> Does anyone know why the previous .jdbc.batcher logic managed the postgre=
s
> partitioned inserts without any issues?
> Are there any other alternative that will allow us to insert into a Postg=
res
> partition table without making massive code changes?

don't know about hibernate or that strange way to insert into partitions.
the postgresql's way is to create triggers on parent table to route
the inserts into the partitions as described here:
http://www.postgresql.org/docs/9.1/static/ddl-partitioning.html

> Would upgrading from 4.1.6.Final to Hibernate 4.1.7 in Linux, fix this
> partitioning ingest problem?
>

don't know, but that certainly looks like a hibernate bug, not a postgresql=
 one

--=20
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitaci=F3n