Transient Table Limitations
The transient table feature has the following limitations:
• Transient tables do not have any backup and recovery mechanism. The tables bypass the Ingres Data Management Facility (DMF) logging mechanism (recovery = 0), and are excluded from “ckpdb” (checkpoints), “rollforwarddb”, and disaster recovery operations.
• You can use foreign key with the following restrictions:
• A permanent table can not have a foreign key that references a transient table. For example, foreign keys in regular tables cannot be linked to transient data.
• A temporary table can not have a foreign key that references a transient table.
• A transient table can not have a foreign key that references a temporary table.
• You cannot create a transient table if a permanent table with the same name already exists. Transient tables share the same namespace as permanent tables.
• Features such as Partitioning, Journaling, Security Auditing, MinMax Indexes and Autotune, and Join Indexes cannot be enabled or utilized along with transient tables.
• Transient tables cannot be zero copy cloned into regular tables.
Last modified date: 09/11/2026