Re: why do we need two snapshots per query?

Simon Riggs <simon(at)2ndQuadrant(dot)com> writes:
> It's all very well to refuse individual cases where linkage is
> required, but ISTM clear that there are many possible uses of being
> able to tell whether a plan is one-shot or not and nothing lost by
> allowing that information (a boolean) pass to the executor.

It's an interconnection between major modules that IMO we don't need.
Having the executor behave differently depending on the planning path
the query took creates complexity, which creates bugs. You haven't
produced any use-case at all that convinces me that it's worth the risk;
nor do I believe there are lots more use-cases right around the corner.

regards, tom lane