Does PBXT support Locking statements (Lock in share mode and for update)

Asked by jason clifton on 2009-10-14

will PBXT honor
SELECT ... FOR UPDATE
AND SELECT ... LOCK IN SHARE MODE

Question information

Language:
English Edit question
Status:
Solved
For:
PBXT Edit question
Assignee:
No assignee Edit question
Solved by:
Paul McCullagh
Solved:
Last query:
Last reply:
Revision history for this message
Best Paul McCullagh (paul-mccullagh) said :
#1

Hi Jason,

PBXT supports SELECT ... FOR UPDATE, but not SELECT ... LOCK IN SHARE MODE.

SELECT ... FOR UPDATE sets exclusive row locks on existing rows.

I have not tested SELECT ... LOCK IN SHARE MODE, but I suspect it will acquire an exclusive row lock, instead of a shared row lock.

Best regards,

Paul

Revision history for this message
jason clifton (jason-citydiesel) said :
#2

Thanks Paul McCullagh, that solved my question.