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

Asked by jason clifton

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.