check if table/object is locked - Mailing list pgsql-sql

From Jonathan Weiss
Subject check if table/object is locked
Date
Msg-id 28935.1047222888@www1.gmx.net
Whole thread Raw
Responses Re: check if table/object is locked  (Rod Taylor <rbt@rbt.ca>)
List pgsql-sql
hi!


i have a problem. i developed an application for administrating cliet and
their sales. if i want to edit a client i load him by select for update. now if
another person want to update him, the query waits, until the first
connection is closed. this is unacceptable, because the whole application is doing
nothing until the db is responding. how can i check if the client is locked
before i want to load him?

thanks,


Jonathan Weiss

-- 
+++ GMX - Mail, Messaging & more  http://www.gmx.net +++
Bitte lächeln! Fotogalerie online mit GMX ohne eigene Homepage!



pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: pl/pgsql how to return multiple values from a function
Next
From: Rod Taylor
Date:
Subject: Re: check if table/object is locked