Re: Index creation fails with automatic names

Поиск
Список
Период
Сортировка
От Vick Khera
Тема Re: Index creation fails with automatic names
Дата
Msg-id CALd+dcchGwLL+u+12kxFxNDpUrWMFiYKdUHDfX8hJFa=7a0oyw@mail.gmail.com
обсуждение исходный текст
Ответ на Index creation fails with automatic names  (Florian Nigsch <flo@nigsch.eu>)
Список pgsql-general

On Mon, Oct 14, 2013 at 6:31 AM, Florian Nigsch <flo@nigsch.eu> wrote:
My question is then - where does this error come from? Is is because Postgres allocates the same name (table1_lower_idx) twice when the index begins building, because at that time there's no index present with that name? But if one index finishes earlier, then the second one can't be committed because it has the same name as an already present index?


looks like the auto-generated names for your indexes clash. Give them explicit names.

Also, subscribe to the list if you want help. this is not your private help desk.

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

Предыдущее
От: Kaveh Mousavi Zamani
Дата:
Сообщение: Missing record in binary replica 9.3.0
Следующее
От: Ian Lawrence Barwick
Дата:
Сообщение: Re: Index creation fails with automatic names