How triggers behave wrt concurrent visibility of transactions?

Posted by stach on Stack Overflow See other posts from Stack Overflow or by stach
Published on 2010-03-28T14:11:31Z Indexed on 2010/03/28 14:13 UTC
Read the original article Hit count: 313

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?

© Stack Overflow or respective owner

Related posts about postgresql

Related posts about triggers