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-03 13:38:54
Message-ID: AEEF32D2527D6E4AB32DFD5125F1B2F8085C5AD7@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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Henrik 2008-06-03 13:41:21 Re: Database growing. Need autovacuum help.
Previous Message Bill Moran 2008-06-03 13:23:04 Re: Database growing. Need autovacuum help.