Constraint or index or both?

Поиск
Список
Период
Сортировка
От Erwin Brandstetter
Тема Constraint or index or both?
Дата
Msg-id 456B1624.5030903@falter.at
обсуждение исходный текст
Ответы Re: Constraint or index or both?  (Dave Page <dpage@postgresql.org>)
Список pgadmin-support
Hi developers! Hi Dave!

Testing 1.6.1 rev: 5646:5664M, client Win XP. Host Debian Sarge, PG 8.1.4

I noticed that primary key and unique constraints (both create an index) 
are listed twice in the object tree, under "Indexes" and "Constraints".
In 1.4.3 those were only listed under "Constraints". I think you changed 
it when fixing the refresh.
It makes sense in a way, but is it on purpose?

ALTER TABLE test ADD CONSTRAINT test_pkey PRIMARY KEY(test_id);
ALTER TABLE test ADD CONSTRAINT test_uni_idx UNIQUE(x, y);

Regards
Erwin


В списке pgadmin-support по дате отправления:

Предыдущее
От: novnov
Дата:
Сообщение: Can tables have calculated columns?
Следующее
От: novnov
Дата:
Сообщение: Upgrading pgAdmin III from 1.4.2 to 1.6.0 on Windows