> The problem with going to EXCLUSIVE manually is that you lock out other > connections for longer than necessary.
I have only one connection that does writes. In any event, I wanted to confirm the readers would work correctly while another connection held an EXCLUSIVE lock, because if they didn't, and the lock eventually went EXCLUSIVE automatically, that might be a problem, and I would prefer to open up a big window for the problem to occur, so I can see it right away, rather than have it hidden in a little tiny window that pops up only rarely.