Does an isolation level still apply until a different one is specified or does it only apply to the next transaction?
For example:
SET TRANSACTION READ WRITE
ISOLTATION LEVEL READ UNCOMMITTED;
SELECT foo FROM aTable;
SELECT bar FROM aTable;
When reading the column bar is the isolation level back to the default serializable?
To make sure I'm not confused, when specifying the isolation level it is dbms wide right?
