Why lost all foreign key constraits after cluster?

Поиск
Список
Период
Сортировка
Искать

Why lost all foreign key constraits after cluster?

От:
Raymond Chui <raymond.chui@noaa.gov>
Дата:

After I performed

cluster indexname on tablename;

All the foreign key constraints are lost on that table, why is that?
I get messages like

NOTICE: DROP TABLE implicitly drops referential integrity
trigger from table "tablename"

during cluster

I don't want to lost the foreign key constraints on the table. How do I
prevent
that? Thank you!


--Raymond

FAQ