Re: bug, ALTER TABLE call ATPostAlterTypeCleanup twice for the same relation

From: jian he <jian(dot)universality(at)gmail(dot)com>
To: Bryan Green <dbryan(dot)green(at)gmail(dot)com>
Cc: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>, David Rowley <dgrowleyml(at)gmail(dot)com>, amul sul <sulamul(at)gmail(dot)com>, Peter Eisentraut <peter(at)eisentraut(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: bug, ALTER TABLE call ATPostAlterTypeCleanup twice for the same relation
Date: 2026-09-15 06:50:49
Message-ID: CACJufxGjyaengAhj=ig+2akoeZjcZQCTrupU=1Q-DHSaGZehWA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Sep 14, 2026 at 5:21 AM Bryan Green <dbryan(dot)green(at)gmail(dot)com> wrote:
>
> On 8/3/2026 1:00 AM, Chao Li wrote:
> >
> >> On Aug 2, 2026, at 19:52, jian he <jian(dot)universality(at)gmail(dot)com> wrote:
> >>

> With that list added, the rest of the approach looks correct to me.
>

Thanks.
I did not notice the newly added AlteredTableInfo->changedStatisticsOwners.
I have added some tests to stats_ext.sql

--
jian
https://www.enterprisedb.com/

Attachment Content-Type Size
v7-0001-Fix-ALTER-TABLE-when-ALTER-TYPE-and-SET-EXPRESSION-are-used-toget.patch application/x-patch 11.9 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message shveta malik 2026-09-15 06:53:15 Re: Proposal: Conflict log history table for Logical Replication
Previous Message Alexandre Felipe 2026-09-15 06:49:31 FIX: BUG #19687: ALTER SEQUENCE missing lock