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

From: amul sul <sulamul(at)gmail(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>
Subject: Re: ALTER INDEX ... ALTER COLUMN not present in dump
Date: 2018-12-17 05:29:08
Message-ID: CAAJ_b95ERJaus8YV9rmC7v0wCqaOhpAYXqxKRC0PCRHphbbvJA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

On Mon, Dec 17, 2018 at 10:44 AM Michael Paquier <michael(at)paquier(dot)xyz> wrote:
>
> On Fri, Dec 14, 2018 at 08:08:45AM +0000, Amul Sul wrote:
> > dump-alter-index-stats-v2.patch looks pretty much reasonable to me, passing on committer.
> >
> > The new status of this patch is: Ready for Committer
>
> Thanks Amul for the review. I got the occasion to look again at this
> patch, and I have read again the original thread which has added the new
> grammar for ALTER INDEX SET STATISTICS:
> https://www.postgresql.org/message-id/CAPpHfdsSYo6xpt0F=ngAdqMPFJJhC7zApde9h1qwkdpHpwFisA@mail.gmail.com
>
> As Alexander and others state on this thread, it looks a bit weird to
> use internally-produced attribute names in those SQL queries, which is
> why the new grammar has been added. At the same time, it looks more
> solid to me to represent the dumps with those column names instead of
> column numbers. Tom, Alexander, as you have commented on the original
> thread, perhaps you have an opinion here to share?
>

Oh I see -- understood the problem, I missed this discussion, thanks to
letting me know.

> For now, attached is an updated patch which has a simplified test list
> in the TAP test. I have also added two free() calls for the arrays
> getting allocated when statistics are present for an index.

Patch is missing?

Regards,
Amul

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2018-12-17 05:35:31 Re: ALTER INDEX ... ALTER COLUMN not present in dump
Previous Message Tom Lane 2018-12-17 05:24:15 Re: ALTER INDEX ... ALTER COLUMN not present in dump

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2018-12-17 05:35:31 Re: ALTER INDEX ... ALTER COLUMN not present in dump
Previous Message Tom Lane 2018-12-17 05:24:15 Re: ALTER INDEX ... ALTER COLUMN not present in dump