| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Yudha Setiawan <yudha(at)bonbon(dot)net> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: LOCK has IGNORED on trigger. |
| Date: | 2003-09-05 13:30:14 |
| Message-ID: | 20030905133014.GA11657@wolff.to |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, Sep 04, 2003 at 13:59:21 +0700,
Yudha Setiawan <yudha(at)bonbon(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | shreedhar | 2003-09-05 13:30:33 | Re: [GENERAL] How can I set postmaster as a service |
| Previous Message | Thomas Wegner | 2003-09-05 13:26:18 | Re: How can I set postmaster as a service |