|
Controls whether the database server performs a COMMIT before an index is created on a local temporary table.
On, Off
On
| PUBLIC role | For current user | For other users | |
|---|---|---|---|
| Allowed to set permanently? | Yes, with SET ANY PUBLIC OPTION | Yes | Yes, with SET ANY PUBLIC OPTION |
| Allowed to set temporarily? | Yes, with SET ANY PUBLIC OPTION | Yes (current connection only) | No |
When this option is set to On, the database server executes a COMMIT before an index is created on a local temporary table. If the commit fails, the operation fails or rolls back. When this option is set to Off (the default), a COMMIT is not performed, which allows a procedure that relies on the index to be used as part of an atomic operation (such as a trigger, UPDATE statement, INSERT statement, DELETE statement, or the FROM clause).