Re: ALTER INDEX ... ALTER COLUMN not present in dump
| От | Ronan Dunklau |
|---|---|
| Тема | Re: ALTER INDEX ... ALTER COLUMN not present in dump |
| Дата | |
| Msg-id | CAARsnT1bK2473gUq09GZXVdn7nCE3eSSgSfsxFzYHgADCEhoUA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: ALTER INDEX ... ALTER COLUMN not present in dump (Sergei Kornilov <sk@zsrv.org>) |
| Ответы |
Re: ALTER INDEX ... ALTER COLUMN not present in dump
|
| Список | 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 --
В списке pgsql-bugs по дате отправления: