Jan Wieck JanWieck at Yahoo.com
Mon Aug 13 11:42:51 PDT 2007
On 8/10/2007 11:04 AM, Simon Riggs wrote:
> Can I just check my understanding?
> 
> Slony single threads access to the log tables indirectly, by making the
> log triggers do a LOCK TABLE on sl_event in EXCLUSIVE mode.
> 
> So we don't actually do LOCK TABLE on sl_log in EXCLUSIVE mode, but that
> is the overall effect?

Where does the log trigger do that? It should not!

What does lock sl_event exclusively is the code that creates events, in 
order to guarantee that events commit in the ev_seqno order and nothing 
else.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #


More information about the Slony1-general mailing list