libpq program SELECT FOR UPDATE and TIMEOUT or CANCEL REQUEST

Поиск
Список
Период
Сортировка
От jrpogo@yahoo.com (Jeffrey Pogodzinski)
Тема libpq program SELECT FOR UPDATE and TIMEOUT or CANCEL REQUEST
Дата
Msg-id 11c19c42.0305190955.967d34@posting.google.com
обсуждение исходный текст
Ответы Re: libpq program SELECT FOR UPDATE and TIMEOUT or CANCEL REQUEST
Список pgsql-sql
Hi,

I am programming using libpq under Linux.

When I do a "select ... for update" to lock a row, how 
would I allow user to cancel or timeout when requesting the
the same row from another program/transaction.

I do not want the user to have to wait for the update on the 
other end. I would rather send the user an error message
saying that the record is LOCKED -- try again later.

If you could send me an example that would be great!

Thanks for your help.

Jeff.

jpogo@imcg.com


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

Предыдущее
От: dan@binaryfrost.net (Dan S)
Дата:
Сообщение: Referencing a column from another table in a different database with a foreign key constraint.
Следующее
От: David W Noon
Дата:
Сообщение: Re: how to use an aggregate function