From: | "Yudha Setiawan" <yudha(at)bonbon(dot)net> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | LOCK has IGNORED on trigger. |
Date: | 2003-09-04 06:59:21 |
Message-ID: | 03be01c372b7$ae0bb3d0$ea00a8c0@yudha |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Dear Expert,
I got a trouble with LOCK on my table (Inquery table).
I've put the LOCK (using select bla.bla for update)
on trigger(trigger insert) of Table_A. It's work properly.
when i tried "insert into Table_A bla.bla.bla" with more
than 5 user in same time
Code...fm_In...fm_Out..fm_Balance
---------------------------------
* 009 3 0 3
# 001 10 0 10
* 009 10 0 13
# 001 10 0 20
* 009 15 0 28
# 001 0 3 17
# 001 0 1 16
# 001 0 4 12
But when i put the "Insert into Table_A" command on
the other trigger's table. That's LOCK is ignored.
Somebody help me please...
GOD Bless You All and Bravo Postgre
-----------------------------------
Yudha Setiawan.
From | Date | Subject | |
---|---|---|---|
Next Message | Giannis Vrentzos | 2003-09-04 07:37:21 | Postgresql book |
Previous Message | AlmawElias Fantahun | 2003-09-04 03:13:00 | Re: unsubscrib |