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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
