Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group