[BUGS] Constraints not check indexes existence on creation.

[Viacheslav N Tararin]

Hi.

--- Next sequence of commans: ---

CREATE TABLE CURRENCY.CURRENCY (
ID integer NOT NULL,
CODE varchar(17) NOT NULL,
DESCRIPTION text,
PRINT_SYMBOL VARCHAR(17) NOT NULL,
VERSION smallint
);

create unique index PK_CURRENCY_IDX on CURRENCY.CURRENCY(ID);
create unique index AK_CODE_CURRENCY_IDX on CURRENCY.CURRENCY(CODE);

alter table CURRENCY.CURRENCY add constraint PK_CURRENCY primary key (ID);
alter table CURRENCY.CURRENCY add constraint AK_CODE_CURRENCY unique (CODE);


--- Produse next table ---

\d currency.currency
Table "currency.currency"
Column | Type | Modifiers
--------------+-----------------------+-----------
id | integer | not null
code | character varying(17) | not null
description | text |
print_symbol | character varying(17) | not null
version | smallint |
Indexes: pk_currency primary key btree (id),
ak_code_currency unique btree (code),
ak_code_currency_idx unique btree (code),
pk_currency_idx unique btree (id)

Why alter table commands not check index existence?
My indexes with _idx postfix similar implicit indexes.
Now it's not problem, but with tablespaces current implementation restrict me to put indexes in separate tablespace.

Thanks.



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly