Postgres Pro
Downloads
Home   >   mailing lists

Bug #895: incorrect error message when duplicate index name - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject Bug #895: incorrect error message when duplicate index name
Date
Msg-id 20030212102649.84C07474E5C@postgresql.org
Whole thread Raw
Responses Re: Bug #895: incorrect error message when duplicate index name  (greg@turnstep.com)
List pgsql-bugs
Tree view 
VIacheslav N Tararin (taras@dekasoft.com.ua) reports a bug with a severity of 4
The lower the number the more severe it is.

Short Description
incorrect error message when duplicate index name

Long Description
ERROR:  relation named "pk_exchange_batch_idx" already exists
Why relation when I create index?


Sample Code
create unique index PK_EXCHANGE_BATCH_IDX   on CURRENCY.EXCHANGE_BATCH(ID);
create        index PK_EXCHANGE_BATCH_IDX   on CURRENCY.EXCHANGE_BATCH(TYPE_ID, FROM_DATE, TO_DATE);


No file was uploaded with this report

pgsql-bugs by date:

Previous
From: "Alexander Stanier"
Date:
Subject: Referential Integrity
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #896: Column Constraint Not Working in ALTER TABLE ADD COLUMN?