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?