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

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: ALTER INDEX ... ALTER COLUMN not present in dump
Дата
Msg-id 20181116133103.GA3427@paquier.xyz
обсуждение исходный текст
Ответ на Re: ALTER INDEX ... ALTER COLUMN not present in dump  (Michael Paquier <michael@paquier.xyz>)
Ответы Re: ALTER INDEX ... ALTER COLUMN not present in dump  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-bugs
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.

+       appendPQExpBuffer(q, "ALTER COLUMN %s ",
+                         indstatcolsarray[j])

This forgot a wrapping with fmtId().  Friday hits hard..
--
Michael

Вложения

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: ALTER INDEX ... ALTER COLUMN not present in dump
Следующее
От: Andrey
Дата:
Сообщение: select (fn()).* executes function multiple times