Re: Row level locking
От | Lincoln Yeoh |
---|---|
Тема | Re: Row level locking |
Дата | |
Msg-id | 5.2.1.1.1.20051012212813.02c28558@localhost обсуждение исходный текст |
Ответ на | Re: Row level locking (Carlos Benkendorf <carlosbenkendorf@yahoo.com.br>) |
Ответы |
Re: Row level locking
|
Список | pgsql-general |
will "lock sometable nowait" help? http://developer.postgresql.org/docs/postgres/sql-lock.html If it fails, something is in progress. I believe there are also statement timeouts. Regards, Link. At 11:56 AM 10/12/2005 +0000, Carlos Benkendorf wrote: >We have applications that are sometimes locked by a long time application >and I would like to avoid these by coding something to discover if the >rows are locked before working with them. > >Both applications use only inserts in a table with a primary key. > >I´m sure that it is not the rigth approach, but I could not figure >something better. Any suggestions? > >Benkendorf
В списке pgsql-general по дате отправления: