TT-05053
Add/Drop foreign keys are not allowed on cached tables
Cause
A primary key is required for all cache groups. Thus, any operation where you try to add or drop a primary key is not allowed. In addition, if you add or drop a foreign key, this may alter the parent/child relationship between the tables in the cache group. Thus, you are not allowed to add or drop a foreign key on a cache table.
Action
Create or drop any primary or foreign key constraints on the tables that are to be cached before creating the cache group.
Additional Information
The operation trying to add or drop the primary key or foreign key constraint on a cache table fails. An index on a cache table cannot be dropped.
TT-05053
Add/Drop foreign keys are not allowed on cached tables
Cause
A primary key is required for all cache groups. Thus, any operation where you try to add or drop a primary key is not allowed. In addition, if you add or drop a foreign key, this may alter the parent/child relationship between the tables in the cache group. Thus, you are not allowed to add or drop a foreign key on a cache table.
Action
Create or drop any primary or foreign key constraints on the tables that are to be cached before creating the cache group.
Additional Information
The operation trying to add or drop the primary key or foreign key constraint on a cache table fails. An index on a cache table cannot be dropped.
TT-05053
Add/Drop foreign keys are not allowed on cached tables
Cause
A primary key is required for all cache groups. Thus, any operation where you try to add or drop a primary key is not allowed. In addition, if you add or drop a foreign key, this may alter the parent/child relationship between the tables in the cache group. Thus, you are not allowed to add or drop a foreign key on a cache table.
Action
Create or drop any primary or foreign key constraints on the tables that are to be cached before creating the cache group.
Additional Information
The operation trying to add or drop the primary key or foreign key constraint on a cache table fails. An index on a cache table cannot be dropped.
