Re: Index creation fails with automatic names - Mailing list pgsql-general

From Vick Khera
Subject Re: Index creation fails with automatic names
Date
Msg-id CALd+dcchGwLL+u+12kxFxNDpUrWMFiYKdUHDfX8hJFa=7a0oyw@mail.gmail.com
Whole thread Raw
In response to Index creation fails with automatic names  (Florian Nigsch <flo@nigsch.eu>)
List 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 by date:

Previous
From: Kaveh Mousavi Zamani
Date:
Subject: Missing record in binary replica 9.3.0
Next
From: Ian Lawrence Barwick
Date:
Subject: Re: Index creation fails with automatic names