Insert into master table ->" 0 rows affected" -> Hibernate problems

From: <Mattias(dot)Arbin(at)tietoenator(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Insert into master table ->" 0 rows affected" -> Hibernate problems
Date: 2008-06-04 07:52:00
Message-ID: AEEF32D2527D6E4AB32DFD5125F1B2F8085C5FF9@maserati.eu.tieto.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have implemented partitioning using inheritance following the proposed
solution here (using trigger):
http://www.postgresql.org/docs/8.3/interactive/ddl-partitioning.html

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.

Is there a solution to this, i.e. to get Postgres to return the correct
number of rows inserted to the master table?


Browse pgsql-general by date

  From Date Subject
Next Message Klint Gore 2008-06-04 08:12:16 Re: psql \e command
Previous Message Per Lauvås 2008-06-04 07:45:43 Re: Failing to recover after panic shutdown