Re: [GENERAL] what's the exact command definition in read committed isolation level?

2016-04-18 Thread Jinhua Luo
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

Re: [GENERAL] what's the exact command definition in read committed isolation level?

2016-04-18 Thread Albe Laurenz
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? >

[GENERAL] what's the exact command definition in read committed isolation level?

2016-04-17 Thread Jinhua Luo
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