Hi Corey,

v2 does not remap anything. It only rejects the stats when the column
names do not match, so the table then shows up in vacuumdb
--missing-stats-only, which is the path you describe. It is 79 lines
plus tests.

The silent case has no dropped column. It is an inheritance child with
its own column order.

  create table p (a int, b int, z int);
  create table ch (z int, b int, a int);
  alter table ch inherit p;
  create statistics ch_s on z, b, a from ch;

After a restore the stats of z land on a, with no warning. A list of
tables with dropped columns does not find it.

Michael, is v2 the rejection you meant, or is the warning we get today
enough?

Thanks,
Shihao

Reply via email to