I read a thread about table lock timeout but don't know whether anything has been done about it.
Here is what I'd like to do:
I don't want my transactions to be on hold for too long so I'd like to use a syntax I use on INFORMIX already:
SET LOCK MODE TO [WAIT [second] | NOT WAIT]
I'm using ecpg and I think I'm up to make a patch to it to support the WAIT [second] with the asynchronous functions but I need a way to know whether a statement would lock from the back-end to implement the NOT WAIT.
Is there a way?
