Re: ALTER INDEX ... ALTER COLUMN not present in dump - Mailing list pgsql-bugs

>
> Hello
> Can you give reproducible example?
> I have ALTER TABLE ONLY (schema).(table) ALTER COLUMN (column) SET STATISTICS (target); in pg_dump output.
>
> regards, Sergei


Please note it is about ALTER INDEX, not ALTER TABLE.

Here is the reproducible example:

create table t1 (id int);
create index on t1 ((id + 2));
alter index t1 alter column t1_expr statistics 10000;

pg_dump output extract:

--
-- Name: t1_expr_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX t1_expr_idx ON public.t1 USING btree (((id + 2)));


--
-- PostgreSQL database dump complete
--