Re: Why does exec_simple_query requires 2 snapshots

Andy Fan <zhihuifan1213(at)163(dot)com> writes:
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
>> Many years ago, we committed a patch to do exactly that. We had
>> to back it out again because it broke too many real-world scenarios.
>> I'm too lazy to search the archives for you, but you might be able
>> to find the commit and revert by searching the git history.

> Commit id is 532994299e2, thank you Tom!

Ah, cool. If you didn't find it already, there should be a
pgsql-hackers or pgsql-bugs thread of approximately that date
with more detail. Sadly, we didn't adopt the convention of
including Discussion: links in commit messages till some
years after that.

regards, tom lane