Re: ALTER INDEX ... ALTER COLUMN not present in dump

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
--

In response to

Responses

Browse pgsql-bugs by date

  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

Browse pgsql-hackers by date

  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