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

BUG #1483: Index problem

From: "Zoltan Szmutku" <hargita(at)freemail(dot)hu>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1483: Index problem
Date: 2005-02-15 12:38:17
Message-ID: 20050215123817.1D8DCF0B12@svr2.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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

Responses

pgsql-bugs by date

Next:From: Jean-Pierre PelletierDate: 2005-02-15 20:29:29
Subject: could not read from statistics collector pipe, Windows 2000, PostgreSQL 8.0.1
Previous:From: Date: 2005-02-15 03:51:17
Subject: O.o.( ).o.O 2

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