This is a multi-part message in MIME format.
------_=_NextPart_001_01C8C57F.2A0C05F2
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
I have implemented partitioning using inheritance following the proposed
solution here (using trigger):
http://www.postgresql.org/docs/8.3/interactive/ddl-partitioning.html
=20
My problem is that when my Hibernate application inserts to the master
table, postgres returns "0 rows affected", which causes Hibernate to
throw an exception since it expects the returned row count to be equal
to the number of rows inserted.
=20
Is there a solution to this, i.e. to get Postgres to return the correct
number of rows inserted to the master table?
=20
------_=_NextPart_001_01C8C57F.2A0C05F2
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.6000.16640" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D826260013-03062008><FONT face=3DArial size=3D2>I have =
implemented=20
partitioning using inheritance following the proposed solution here =
(using=20
trigger):</FONT></SPAN></DIV>
<DIV><SPAN class=3D826260013-03062008><FONT face=3DArial size=3D2><A=20
href=3D"http://www.postgresql.org/docs/8.3/interactive/ddl-partitioning.h=
tml">http://www.postgresql.org/docs/8.3/interactive/ddl-partitioning.html=
</A></FONT></SPAN></DIV>
<DIV><SPAN class=3D826260013-03062008><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D826260013-03062008><FONT face=3DArial size=3D2>My =
problem is that=20
when my Hibernate application inserts to the master table, postgres =
returns "0=20
rows affected", which causes Hibernate to throw an exception since =
it=20
expects the returned row count to be equal to the number of rows=20
inserted.</FONT></SPAN></DIV>
<DIV><SPAN class=3D826260013-03062008><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D826260013-03062008><FONT face=3DArial size=3D2>Is =
there a solution=20
to this, i.e. to get Postgres to return the correct number of rows =
inserted to=20
the master table?</FONT></SPAN></DIV>
<DIV><FONT face=3DArial size=3D1></FONT> </DIV></BODY></HTML>
------_=_NextPart_001_01C8C57F.2A0C05F2--
