From: | Ronan Dunklau <ronan(dot)dunklau(at)people-doc(dot)com> |
---|---|
To: | sk(at)zsrv(dot)org |
Cc: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: ALTER INDEX ... ALTER COLUMN not present in dump |
Date: | 2018-11-15 10:52:41 |
Message-ID: | CAARsnT1bK2473gUq09GZXVdn7nCE3eSSgSfsxFzYHgADCEhoUA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
>
> 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
--
From | Date | Subject | |
---|---|---|---|
Next Message | Sergei Kornilov | 2018-11-15 11:20:01 | Re: ALTER INDEX ... ALTER COLUMN not present in dump |
Previous Message | Sergei Kornilov | 2018-11-15 10:44:42 | Re: ALTER INDEX ... ALTER COLUMN not present in dump |
From | Date | Subject | |
---|---|---|---|
Next Message | Ideriha, Takeshi | 2018-11-15 11:02:10 | RE: Protect syscache from bloating with negative cache entries |
Previous Message | Sergei Kornilov | 2018-11-15 10:44:42 | Re: ALTER INDEX ... ALTER COLUMN not present in dump |