Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id C85462E003D for ; Thu, 22 Nov 2007 14:46:27 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 62855-02 for ; Thu, 22 Nov 2007 14:46:24 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id D97D12E0032 for ; Thu, 22 Nov 2007 14:46:24 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.1/8.14.1) with ESMTP id lAMIkNU5052181 for ; Thu, 22 Nov 2007 14:46:23 -0400 (AST) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.1/8.14.1/Submit) id lAMIVLFP025858 for pgsql-admin@postgresql.org; Thu, 22 Nov 2007 14:31:21 -0400 (AST) (envelope-from news) From: PostgreSQL X-Newsgroups: pgsql.admin Subject: Row Lock Date: Thu, 22 Nov 2007 16:31:20 -0200 Organization: Hub.Org Networking Services Lines: 12 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/202 X-Sequence-Number: 27445 I'm having a problem with some row locks where one user does the lock and another user try to do the same, but of course, the second one will be waiting the first user unlock it. I would like to know if there is a way to discover if that row is locked before I try to do the lock. I have been researching something like ROWID but I couldn't find anything useful. Thank's