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

From Zoltan Szmutku
Subject BUG #1483: Index problem
Date
Msg-id 20050215123817.1D8DCF0B12@svr2.postgresql.org
Whole thread Raw
Responses Re: BUG #1483: Index problem  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-bugs
The following bug has been logged online:

Bug reference:      1483
Logged by:          Zoltan Szmutku
Email address:      hargita@freemail.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

pgsql-bugs by date:

Previous
From: "Shujun Huang"
Date:
Subject: BUG #1482: SQL ERROR IN 7.4.7
Next
From: Bruno Wolff III
Date:
Subject: Re: BUG #1483: Index problem