Re: Why does exec_simple_query requires 2 snapshots

Andy Fan <zhihuifan1213@163.com> writes:
> Tom Lane <tgl@sss.pgh.pa.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