RE: BUG #16342: CREATE TABLE LIKE INCLUDING GENERATED column order issue

From: Ethan Waldo <ewaldo(at)healthetechs(dot)com>
To: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: RE: BUG #16342: CREATE TABLE LIKE INCLUDING GENERATED column order issue
Date: 2020-04-09 14:55:25
Message-ID: DM5PR0601MB3750DE8B9595D2E9848920C9B1C10@DM5PR0601MB3750.namprd06.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Thank you for such a timely response and the best and most fully featured database software money can't buy!

Sent from my Samsung Galaxy smartphone.

-------- Original message --------
From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
Date: 4/9/20 10:48 AM (GMT-05:00)
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Ethan Waldo <ewaldo(at)healthetechs(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #16342: CREATE TABLE LIKE INCLUDING GENERATED column order issue

On 2020-04-05 17:26, Tom Lane wrote:
> Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> writes:
>> Confirmed. Attached is a patch to fix it. Thanks for the report!
>
> LGTM. Perhaps extend the comment block just above, adding something
> like "We must fill the attmap now so it can be used to process
> GENERATED default expressions in the per-column loop."

Committed with that.

Ethan, this will be in the next minor release of PostgreSQL 12.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Daniel Verite 2020-04-09 15:58:24 Re: BUG #16351: PostgreSQL closing connection during requests with segmentation fault
Previous Message Peter Eisentraut 2020-04-09 14:48:29 Re: BUG #16342: CREATE TABLE LIKE INCLUDING GENERATED column order issue