How to avoid the Mutating Triggers ??

Поиск
Список
Период
Сортировка
От Yudha Setiawan
Тема How to avoid the Mutating Triggers ??
Дата
Msg-id 01c801c2d81a$414f4aa0$ea00a8c0@yudha
обсуждение исходный текст
Ответы Re: How to avoid the Mutating Triggers ??  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Nathalie Boulos"
Дата:
Сообщение: encoding problem
Следующее
От: Kurt
Дата:
Сообщение: pg_dump error after upgrade