Re: Postgres Partitions not working with hibernate 4.1.6.Final - Mailing list pgsql-bugs

From Jaime Casanova
Subject Re: Postgres Partitions not working with hibernate 4.1.6.Final
Date
Msg-id CAJKUy5i6_pxNmvzu+JTXaoWy3eEynNFdrOnGdNPPoh1XbeZmQA@mail.gmail.com
Whole thread Raw
In response to Postgres Partitions not working with hibernate 4.1.6.Final  ("Freddie Burgess" <fburgess@radiantblue.com>)
Responses Re: Postgres Partitions not working with hibernate 4.1.6.Final  ("Freddie Burgess" <fburgess@radiantblue.com>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: "Freddie Burgess"
Date:
Subject: Postgres Partitions not working with hibernate 4.1.6.Final
Next
From: "Freddie Burgess"
Date:
Subject: Re: Postgres Partitions not working with hibernate 4.1.6.Final