From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | Mattias(dot)Arbin(at)tietoenator(dot)com |
Cc: | scott(dot)marlowe(at)gmail(dot)com, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Insert into master table ->" 0 rows affected" -> Hibernate problems |
Date: | 2008-06-10 08:43:03 |
Message-ID: | 484E3E97.8000706@hagander.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I think that if you use a RULE instead of a TRIGGER to redirect the
write, it should return the proper number of rows inserted in the child
table.
//Magnus
Mattias(dot)Arbin(at)tietoenator(dot)com wrote:
> Scott,
> You're right, of course. I meant, is there a way to make Postgres return
> the number of rows inserted to any child table _via_ the master table +
> trigger function?
> I have not been able to find a way to tell Hibernate to ignore the
> returned number of rows, unless I insert via a custom insert statement.
> /Mattias
>
> -----Original Message-----
> From: Scott Marlowe [mailto:scott(dot)marlowe(at)gmail(dot)com]
> Sent: den 5 juni 2008 02:01
> To: Arbin Mattias
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Insert into master table ->" 0 rows affected" ->
> Hibernate problems
>
> On Tue, Jun 3, 2008 at 7:38 AM, <Mattias(dot)Arbin(at)tietoenator(dot)com> wrote:
>> 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?
>
> PostgreSQL IS reporting the correct number of rows inserted into the
> master table. 0.
>
> There's some setting in hibernate that will tell it to ignore that
> returned number of rows, but I can't remember it right now.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Hermann Muster | 2008-06-10 09:09:30 | Re: Accessing other databases with DBLink when leaving user/password empty |
Previous Message | Tommy Gildseth | 2008-06-10 08:19:44 | Re: Re: Accessing other databases with DBLink when leaving user/password empty |