Re: Row level locking

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