Re: ERROR: virtual tuple table slot does not have system attributes
Andres Freund <andres@anarazel.de>
From: Andres Freund <andres@anarazel.de>
To: Jeff Janes <jeff.janes@gmail.com>,Roby <pacman@finefun.com.au>
Cc: pgsql-bugs@lists.postgresql.org
Date: 2019-06-30T00:50:03Z
Lists: pgsql-bugs
Hi, On June 29, 2019 5:47:18 PM PDT, Jeff Janes <jeff.janes@gmail.com> wrote: >On Fri, Jun 28, 2019 at 5:38 AM Roby <pacman@finefun.com.au> wrote: > >> Hi, >> >> Thank you all very much for your work on Postgres. >> >> I have encountered the following error in 12b2 in code that has been >> working fine for a while in version 11. >> >> A test script is attached, the output of which follows. >> >> >Thanks for the reproducible test case. This bisects down to this >commit, > >commit 277cb789836b5ddf81aabb80c2058268c70e2f36 >Author: Andres Freund <andres@anarazel.de> >Date: Wed Mar 6 15:43:33 2019 -0800 > >Don't reuse slots between root and partition in ON CONFLICT ... UPDATE. > >I was a little surprised it was this particular commit, because your >test >doesn't use partitioning. > >I don't know how to investigate the issue further, so I'm copying >Andres >and will add it to the open issues page. Thanks, will have a look. Andres -- Sent from my Android device with K-9 Mail. Please excuse my brevity.
Commits
-
Fix system column accesses in ON CONFLICT ... RETURNING.
- f9257cffef3b 12.0 landed
- ecbdd009344d 13.0 landed
-
Don't reuse slots between root and partition in ON CONFLICT ... UPDATE.
- 277cb789836b 12.0 cited