Constraints not check indexes existence on creation.
От | Viacheslav N Tararin |
---|---|
Тема | Constraints not check indexes existence on creation. |
Дата | |
Msg-id | 3E4A2655.90506@dekasoft.com.ua обсуждение исходный текст |
Ответы |
Re: Constraints not check indexes existence on creation.
|
Список | pgsql-bugs |
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.
В списке pgsql-bugs по дате отправления: