>>>>> "Chapman" == Chapman Flack <c...@anastigmatix.net> writes:
Chapman> AFAICS, that is *all* that comment block has to say about why Chapman> there's an active snapshot stack. I believe you are saying it Chapman> has another important function, namely that its top element is Chapman> what tells the executor what can be seen. That's not precisely true - ultimately, the routines that do actual scans take the snapshot to use as a parameter, and the executor mostly references the snapshot from the EState; but a bunch of places do require that ActiveSnapshot be set to the currently applicable snapshot (e.g. for queries inside stable functions nested inside the main query). -- Andrew (irc:RhodiumToad)