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

From: Adrien Nayrat <adrien(dot)nayrat(at)anayrat(dot)info>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: ALTER INDEX ... ALTER COLUMN not present in dump
Date: 2018-11-21 08:09:36
Message-ID: e5632dc9-feac-cb02-26ec-d6aaf55a666e@anayrat.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

On 11/21/18 1:04 AM, Michael Paquier wrote:
> On Fri, Nov 16, 2018 at 10:31:03PM +0900, Michael Paquier wrote:
>> On Fri, Nov 16, 2018 at 05:32:52PM +0900, Michael Paquier wrote:
>>> And here you go as attached. Looking closer, in v10 and older versions,
>>> ALTER INDEX SET STATISTICS is able to work as it is an alias of ALTER
>>> TABLE. The attached patch does not bother generating the ALTER INDEX
>>> queries for v10 and older and feeds queries with empty strings. Perhaps
>>> we should support that case? Or the lack of complains would be an
>>> argument sufficient to care only about v11 and newer versions? I would
>>> tend to think that supporting only v11 and above is enough. Thoughts
>>> are welcome.
>
> So, any thoughts about this patch? I would still like to move on with
> only supporting this set of queries only for v11 and above as that gets
> only clearly documented on the ALTER INDEX page from that point.
> --
> Michael
>

Sorry, I will try to look at this soon, but it is relatively new for me.
At least, someone else with more knowledge should also look.

Thanks to address this issue.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Shkola, Roman 2018-11-21 10:24:12 BYTEA data type problem
Previous Message Michael Paquier 2018-11-21 07:18:58 Re: BUG #15514: process fails on jsonb_populate_recordset query. see simple example below

Browse pgsql-hackers by date

  From Date Subject
Next Message Christoph Berg 2018-11-21 08:20:43 Re: pgsql: Remove WITH OIDS support, change oid catalog column visibility.
Previous Message Adrien Nayrat 2018-11-21 08:06:40 Re: New GUC to sample log queries