Re: Index file got removed

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Index file got removed
Дата
Msg-id CAB7nPqSS9+pVXFoW-WKp7NOep4usfR+3oDq3M3LoSdNbDmzLBw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Index file got removed  (Michael Paquier <michael.paquier@gmail.com>)
Ответы Re: Index file got removed  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
On Thu, Nov 24, 2016 at 8:31 AM, Michael Paquier
<michael.paquier@gmail.com> wrote:
> On Thu, Nov 24, 2016 at 7:46 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> For instance, wouldn't it change the behavior of ALTER TABLE ADD
>> PRIMARY KEY?
>
> Good point. I forgot this one.

And I just wrote a test case breaking my previous patch, please see
attached. The idea is just to use ADD CONSTRAINT foo { PRIMARY KEY |
UNIQUE } and check if default_tablespace works as expected. Perhaps
that's worth having in the test suite? There is currently no coverage
regarding for index additions done with ALTER TABLE and tablespaces.
--
Michael

Вложения

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Index file got removed
Следующее
От: 张嘉志
Дата:
Сообщение: Re: got some errors after upgrade poestgresql from 9.5 to 9.6