I`m doing some research about locking for a blogentry and I can`t find the answer to a question.
The question is:
If the isolation level is serializable (and you are working with a database) is the complete table locked when it is queried (for the duration of the transaction) ?
For repeatable read you get row locks, but it allows phantom reads. The only way to make sure you don`t get phantom reads (in the serialized isolation level) is by having a complete table lock.
Or could it be that it totally up to the database implementation what is locked?