ALTER INDEX ... ALTER COLUMN not present in dump

From: Ronan Dunklau <ronan(dot)dunklau(at)people-doc(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: ALTER INDEX ... ALTER COLUMN not present in dump
Date: 2018-11-15 10:23:24
Message-ID: CAARsnT3UQ4V=yDNW468w8RqHfYiY9mpn2r_c5UkBJ97NAApUEw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Hello,

It seems like ALTER INDEX ... ALTER COLUMN statements (for setting specific
statistics targets on functional indexes, for example) are not part of a
pg_dump.

It is not easily noticed, since everything seems to work normally until a
sub-par plan is chosen because of an error in cardinality estimates.

Regards,

--
Ronan Dunklau

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Sergei Kornilov 2018-11-15 10:44:42 Re: ALTER INDEX ... ALTER COLUMN not present in dump
Previous Message Yogesh 2018-11-15 07:15:30 Re: BUG #15508: Not able to connect irrespective of valid entries in pg_hba.conf

Browse pgsql-hackers by date

  From Date Subject
Next Message John Naylor 2018-11-15 10:25:21 Re: [RFC] Removing "magic" oids
Previous Message Amit Kapila 2018-11-15 10:11:03 Re: reloption to prevent VACUUM from truncating empty pages at the end of relation