On Mon, Oct 23, 2006 at 05:31:33PM -0600, paul cannon wrote:
> So I guess the slony stored procedures were being cached or something,
> or updates do not become visible in parallel connections? That's an area
> of postgres about which I know very little.

Right; the basic problem is that stored procedure query plans are
cached, and there's no generic invalidation support.  There's a lot
of historical discussion of this on -hackers, which boils down to
"this is reasonably hard, and lower priority than feature X".  But
there's some suggestion that one of the excellent back end developers
will do something about this in the next release.

A

-- 
Andrew Sullivan  | ajs at crankycanuck.ca
Information security isn't a technological problem.  It's an economics
problem.
		--Bruce Schneier