The following bug has been logged online:

Bug reference: 1483
Logged by: Zoltan Szmutku
Email address: hargita (AT) freemail (DOT) hu
PostgreSQL version: 8.01
Operating system: Win 2000
Description: Index problem
Details:

Hello,

I now try first the PostgreSql. Before I use the MySQL but, for my new works
I need use the advanced transactions handle.

I have 2 tables : 'proba' and 'proba2' .

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 ?

Thanks : Zoltan

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

On Tue, Feb 15, 2005 at 12:38:17 +0000,
Zoltan Szmutku <hargita (AT) freemail (DOT) hu> wrote:
Because you tried to name both indexes the same name. Perhaps you might
use something like proba_kod and proba2_kod?

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings