LOCK has IGNORED on trigger.

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.

Responses

Browse pgsql-admin by date

  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