Vinay Banakar <vinay.s.banakar@gmail.com> writes: > Thank you for finding the root cause, I just checked on 9.15.17 and it is > still failing here also. > But I distinctly remember it working earlier, not sure which version of pg > (at least <9.5.16) though as I have lost that earlier setup.
Oh! I misread your report as being that it worked on 9.5.x and failed on 9.6.x. If it really did work on some earlier 9.5.x version, then we must've busted it with a patch ... but what? That bizarre code in ExecEvalWholeRowVar is much older than 9.5 (looks like it dates to 8e617e29a), and the mistake proper goes back to the introduction of WITH CHECK OPTION in 9.4 (4cbe3ac3e). I'm not seeing any other moving parts here.