How to avoid the Mutating Triggers ??

From: "Yudha Setiawan" <yudha(at)BonBon(dot)net>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: How to avoid the Mutating Triggers ??
Date: 2003-02-19 12:59:22
Message-ID: 01c801c2d81a$414f4aa0$ea00a8c0@yudha
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Dear Master,
I've some problem with this situation.
It's hard to explain what kind of
problem is, but i try to tell you
with my limitation on english.

How do I "recalculate" one of
my field, if i updated one of
the record that's have position
in the middle of all record.
Here my Ilustration is;
----------------------------------------
Poin-|FdDate | Code| IN |OUT| Qty |
ter. |----------------------------------
1 |01/01/2003 | 001 | 5 | 0 | 5 |
2 |01/02/2003 | 001 | 3 | 0 | 8 |
3 |01/03/2003 | 001 | 0 | 1 | 7 |
4 |01/06/2003 | 001 | 100 | 0 | 117 |
5 |00107/2003 | 001 | 0 | 1 | 118 |
6 |00108/2003 | 001 | 0 | 1 | 119 |
7 |00109/2003 | 001 | 0 | 1 | 120 |
----------------------------------------
And what i want is, update the record
on Pointer no 4. on "IN" is changed from
100 to 10 And Qty is Automaticly change
from 117 to 17. like this;
----------------------------------------
Poin-|FdDate | Code| IN |OUT| Qty |
ter. |----------------------------------
4 |01/06/2003 | 001 | 10 | 0 | 17 |
----------------------------------------
Following with record below it, and become
like this;
----------------------------------------
Poin-|FdDate | Code| IN |OUT| Qty |
ter. |----------------------------------
5 |00107/2003 | 001 | 0 | 1 | 18 |
6 |00108/2003 | 001 | 0 | 1 | 19 |
7 |00109/2003 | 001 | 0 | 1 | 20 |
----------------------------------------

I've been trying using cursor inside of
my trigger, It didn't work and it's
"mutating". i thought my trigger is
working recursive. It's very Urgent
for me. I've been migrating Database
from Ms-SQL, so far so great, till
this Problem I've been spending my
3 Days with No-Result.
It's time to Give-up.
So gimme your hand please...???

Thank's to you and,
GOD Bless You All.

Yudha Setiawan.
VoIP
No. : 628899911223344

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kurt 2003-02-19 15:28:56 pg_dump error after upgrade
Previous Message Nathalie Boulos 2003-02-19 12:00:59 encoding problem