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:
2009-10-26
Last query:
2009-10-26
Last reply:
2009-10-26

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

Thanks Paul McCullagh, that solved my question.