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

  1. Fix system column accesses in ON CONFLICT ... RETURNING.

  2. Don't reuse slots between root and partition in ON CONFLICT ... UPDATE.