Skip site navigation (1) Skip section navigation (2)

Locking Question

From: Terry Lee Tucker <terry(at)esc1(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Locking Question
Date: 2004-06-10 18:09:13
Message-ID: 200406101409.13547.terry@esc1.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
Good Day,

I'm working on a transportation application which is written in C using 
X-Windows. I've been experiementing with various methods for row level 
locking. This application will be used by about 70 people at once with many 
updates occurring to much of the data. At present, I'm looking at serialized 
transactions. I have discovered that if the interface runs into a record that 
is currently being updated with a SELECT FOR UPDATE, it sits and waits. I'm 
looking for a way to get feedback to the user. I'm executing the SELECT FOR 
UPDATE with a PQexec. PQexec blocks and waits. If I use PQsendQuery to 
execute the statement, will I be able to get some sort of feed back from that 
as to what is going on?
-- 
Quote: 35
"Losing [the debate about marriage] means losing marriage as a social
 institution, a shared public norm. The question is not whether this
 is a battle we can win, but whether it is a battle we can afford to
 lose."

 --Maggie Gallagher

 Work: 1-336-372-6812
 Cell: 1-336-363-4719
email: terry(at)esc1(dot)com

pgsql-interfaces by date

Next:From: L J BayukDate: 2004-06-10 23:44:54
Subject: Re: libpq 7.4 and binary cursor
Previous:From: Jeroen T. VermeulenDate: 2004-06-10 16:58:51
Subject: Re: libpq 7.4 and binary cursor

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group