Let me clarify my question a bit more (I don't know why nobody raises
such question):
For trigger, e.g. written in pl/pgsql, each sql command within the
function may see more new data beyond the (entry) snapshot of outer
command.
So if the "command" term in the read committed isolation level
Jinhua Luo wrote:
> The document said, "Read Committed mode starts each command with a new
> snapshot that includes all transactions committed up to that instant".
>
> But what about the embedded commands within the outer command itself?
> Do they share the same snapshot with the outer command?
>
Hi All,
The document said, "Read Committed mode starts each command with a new
snapshot that includes all transactions committed up to that instant".
But what about the embedded commands within the outer command itself?
Do they share the same snapshot with the outer command?
a) trigger
This is