Postgres Pro
Downloads
Home   >   mailing lists

Timeout for lock table - Mailing list pgsql-sql

From Jonathan Man
Subject Timeout for lock table
Date
Msg-id 000801c34048$748fccf0$8401a8c0@equity.com
Whole thread Raw
List pgsql-sql
Tree view
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
 

pgsql-sql by date:

Previous
From: "Don Soledad"
Date:
Subject: columnar format
Next
From: Ang Chin Han
Date:
Subject: Re: LEAST and GREATEST functions?