Locking Question

Поиск
Список
Период
Сортировка
От Terry Lee Tucker
Тема Locking Question
Дата
Msg-id 200406101409.13547.terry@esc1.com
обсуждение исходный текст
Список 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 socialinstitution, a shared public norm. The question is
notwhether thisis a battle we can win, but whether it is a battle we can afford tolose."
 
--Maggie Gallagher
Work: 1-336-372-6812Cell: 1-336-363-4719
email: terry@esc1.com


В списке pgsql-interfaces по дате отправления:

Предыдущее
От: "Jeroen T. Vermeulen"
Дата:
Сообщение: Re: libpq 7.4 and binary cursor
Следующее
От: L J Bayuk
Дата:
Сообщение: Re: libpq 7.4 and binary cursor