On Tue, Oct 23, 2018 at 5:49 PM Haribabu Kommi <kommi.haribabu@gmail.com> wrote:I am able to generate the simple test and found the problem. The issue with the followingSQL.SELECT * INTO TABLE xacttest FROM aggtest;During the processing of the above query, the tuple that is selected from the aggtest is sent to the intorel_receive() function, and the same tuple is used for the insert, becauseof this reason, the tuple xmin is updated and it leads to failure of selecting the data fromanother query. I fixed this issue by materializing the slot.Wrong patch attached in the earlier mail, sorry for the inconvenience.Attached proper fix patch.I will look into isolation test failures.
I am able to generate the simple test and found the problem. The issue with the followingSQL.SELECT * INTO TABLE xacttest FROM aggtest;During the processing of the above query, the tuple that is selected from the aggtest is sent to the intorel_receive() function, and the same tuple is used for the insert, becauseof this reason, the tuple xmin is updated and it leads to failure of selecting the data fromanother query. I fixed this issue by materializing the slot.
pgsql-hackers by date:
Соглашаюсь с условиями обработки персональных данных