How triggers behave wrt concurrent visibility of transactions?
- by stach
I'm working on PostgreSQL 8.4 in read committed mode.
I know that for each query, the server makes a snapshot of db state so that
the query behaves consistently.
Does it include triggers that are called in response to this query?
Or is there a new snapshot created for each query called from within a trigger?