Re: Stored columns: Unexpected varattno in expression to be mapped

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Thiede, Christoph" <Christoph(dot)Thiede(at)student(dot)hpi(dot)uni-potsdam(dot)de>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: Stored columns: Unexpected varattno in expression to be mapped
Date: 2020-07-17 00:50:50
Message-ID: 20200717005050.GB2122@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, Jul 16, 2020 at 12:10:35PM -0400, Tom Lane wrote:
> Thanks for the report! Trying this locally, it seems to work in
> either HEAD or v12 branch tip, so I think we fixed the bug already.
> I recall some recent work around this area, so that conclusion
> is not surprising. What I don't recall is whether those fixes
> were before or after 12.3. You might find that updating to 12.3
> fixes it; if not, it should be fixed in next month's 12.4 release.

12.3 works properly, so you could just update to the latest minor
version already released. Here is the commit:
commit: e92e4a2b68fe877677278c1300db1780956c984e
author: Peter Eisentraut <peter(at)eisentraut(dot)org>
date: Thu, 9 Apr 2020 16:17:55 +0200
Fix CREATE TABLE LIKE INCLUDING GENERATED column order issue

And here is the related thread:
https://www.postgresql.org/message-id/16342-50008a509308f4ca@postgresql.org
--
Michael

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Thiede, Christoph 2020-07-17 01:04:17 AW: Stored columns: Unexpected varattno in expression to be mapped
Previous Message Tom Lane 2020-07-16 16:10:35 Re: Stored columns: Unexpected varattno in expression to be mapped