Re: BUG #1483: Index problem - Mailing list pgsql-bugs

From Bruno Wolff III
Subject Re: BUG #1483: Index problem
Date
Msg-id 20050216184830.GA15989@wolff.to
Whole thread Raw
In response to BUG #1483: Index problem  ("Zoltan Szmutku" <hargita@freemail.hu>)
List pgsql-bugs
On Tue, Feb 15, 2005 at 12:38:17 +0000,
  Zoltan Szmutku <hargita@freemail.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?

pgsql-bugs by date:

Previous
From: "Zoltan Szmutku"
Date:
Subject: BUG #1483: Index problem
Next
From: "ÔíãÇÁ" "ÓÇãì"
Date:
Subject: O.o.( ÃÓÑÉ ÓíÝ Çááå ).o.O ÈÍÑ ÇáÏãæÚ 2