Hi
I have this scenario and would like to use lock table for this but I
don't know which mode I should use.
When I delete/update/insert a record from/to a table, I need to update
some fields of all the records in this table. During this process I
don't want anyone to insert, update or delete the data but allow them
to select the data at the original state.
I am currently using:
LOCK TABLE tbl_name IN SHARE ROW EXCLUSIVE MODE
Is this the correct mode to use?
Thanks,
Ben