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
