On Thu, Sep 04, 2003 at 13:59:21 +0700,
Yudha Setiawan <yudha@bonbon.net> wrote:
> 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
>
> But when i put the "Insert into Table_A" command on
> the other trigger's table. That's LOCK is ignored.
A select for update isn't going to block an insert. If you need that, you
have to lock the whole table.