Re: BUG #1483: Index problem

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Zoltan Szmutku <hargita(at)freemail(dot)hu>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1483: Index problem
Date: 2005-02-16 18:48:30
Message-ID: 20050216184830.GA15989@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tue, Feb 15, 2005 at 12:38:17 +0000,
Zoltan Szmutku <hargita(at)freemail(dot)hu> wrote:
>
> My next commands :
>
> 1.
> CREATE UNIQUE INDEX kod
> ON proba
> USING btree
> (mezo1)
>
> 2.
> CREATE UNIQUE INDEX kod
> ON proba2
> USING btree
> (mezo1)
>
> The second command not success, I get the error message :
>
> ERROR: relation "kod" already exists
>
> Why ?

Because you tried to name both indexes the same name. Perhaps you might
use something like proba_kod and proba2_kod?

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-02-16 20:05:17 Re: Postgres crashed on invalid IP entry in pg_hba.conf
Previous Message pkalva 2005-02-16 18:36:26 Postgres crashed on invalid IP entry in pg_hba.conf