Timeout for lock table

From: "Jonathan Man" <jman(at)equityunderwriters(dot)com(dot)hk>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Timeout for lock table
Date: 2003-07-02 03:17:22
Message-ID: 000801c34048$748fccf0$8401a8c0@equity.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Dear All,

I begin a transaction. I then execute a SQL command "SELECT FOR UPDATE" to lock some records on the first session. Besides, I also lock some rows using the same method on the second session. Is it possible to return an error message to indicate that some records were locked by another user when I lock it on the second session?

Please help me, THX!!

JMAN

Browse pgsql-sql by date

  From Date Subject
Next Message Rudi Starcevic 2003-07-02 03:59:50 Break referential integrity.
Previous Message Don Soledad 2003-07-02 02:42:58 columnar format