function Truncate::execute

Executes the TRUNCATE query.

In most cases, TRUNCATE is not a transaction safe statement as it is a DDL statement which results in an implicit COMMIT. When we are in a transaction, fallback to the slower, but transactional, DELETE. PostgreSQL also locks the entire table for a TRUNCATE strongly reducing the concurrency with other transactions.

Overrides Truncate::execute

File

core/modules/pgsql/src/Driver/Database/pgsql/Truncate.php, line 15

Class

Truncate

PostgreSQL implementation of \Drupal\Core\Database\Query\Truncate.

Namespace

Code

public function execute() : void {
  if ($this->connection
    ->inTransaction()) {
    $savepoint = $this->connection
      ->startTransaction('mimic_implicit_commit');
  }
  try {
    parent::execute();
  } catch (\Exception $e) {
    if (isset($savepoint)) {
      $savepoint->rollback();
    }
    throw $e;
  }
  if (isset($savepoint)) {
    $savepoint->commitOrRelease();
  }
}