Re: BUG #19833: ALTER TABLE that rebuilds an extended statistics object silently drops its SET STATISTICS target (st

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Rahila Syed <rahilasyed90(at)gmail(dot)com>
Cc: 303677365(at)qq(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #19833: ALTER TABLE that rebuilds an extended statistics object silently drops its SET STATISTICS target (st
Date: 2026-11-12 02:55:28
Message-ID: avUqoD3yBtaUm7Y2@paquier.xyz
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wed, Nov 11, 2026 at 04:27:37PM +0800, Rahila Syed wrote:
> ALTER TABLE st2 ALTER COLUMN c TYPE int;
>
> SELECT i.indexrelid::regclass::text AS index_name, a.attstattarget
> FROM pg_index i JOIN pg_attribute a ON a.attrelid = i.indexrelid AND
> a.attnum = 1 WHERE i.indrelid = 'st2'::regclass;
> index_name | attstattarget
> ------------+---------------
> st2_cb |
> (1 row)

Hmm, yes, that feels counter-intuitive to not preserve that.

> I will look into writing a fix for this.

Cool, thanks.
--
Michael

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2026-11-12 03:13:20 Re: BUG #19848: BEGIN ATOMIC with unnamed/OUT params breaks restore and pg_upgrade
Previous Message PG Bug reporting form 2026-11-12 02:47:16 BUG #19895: dblink() never returns and spins at 100% CPU when the remote command is COPY ... TO STDOUT;