Concepts > Attributes (MetaAttributes) > ON COMMIT \ PostgreSQL
ON COMMIT \ PostgreSQL
The behavior of temporary tables at the end of a transaction block can be controlled using ON
COMMIT. The three options are:
PRESERVE ROWS
No special action is taken at the ends of transactions. This is the default behavior.
DELETE ROWS
All rows in the temporary table will be deleted at the end of each transaction block. Essentially,
an automatic TRUNCATE is done at each commit.
DROP
The temporary table will be dropped at the end of the current transaction block.
Translations
Type
String (2) Enumeration
 
List of MetaClasses
Value
(DR), (DP), (PR).