Re: ERROR: virtual tuple table slot does not have system attributes
Jeff Janes <jeff.janes@gmail.com>
From: Jeff Janes <jeff.janes@gmail.com>
To: Roby <pacman@finefun.com.au>
Cc: pgsql-bugs@lists.postgresql.org, Andres Freund <andres@anarazel.de>
Date: 2019-06-30T00:47:18Z
Lists: pgsql-bugs
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.
Cheers,
Jeff
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