Re: Index creation fails with automatic names

From: Vick Khera <vivek(at)khera(dot)org>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Index creation fails with automatic names
Date: 2013-10-17 13:09:59
Message-ID: CALd+dcchGwLL+u+12kxFxNDpUrWMFiYKdUHDfX8hJFa=7a0oyw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Oct 14, 2013 at 6:31 AM, Florian Nigsch <flo(at)nigsch(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kaveh Mousavi Zamani 2013-10-17 13:13:43 Missing record in binary replica 9.3.0
Previous Message Kaveh Mousavi Zamani 2013-10-17 13:02:46 Missing record in binary replica 9.3.0