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?
|
- Re: [HACKERS] How to know whether a table is locked ? Nicolas Bazin
- Re: [HACKERS] How to know whether a table is locked ? Bruce Momjian