Rename a table.

Parameters

$table: The table to be renamed.

$new_name: The new name for the table.

Throws

DatabaseSchemaObjectDoesNotExistException If the specified table doesn't exist.

DatabaseSchemaObjectExistsException If a table with the specified new name already exists.

Overrides DatabaseSchema::renameTable

File

drupal-7.x/includes/database/pgsql/schema.inc, line 315

Database schema code for PostgreSQL database servers.

Class

DatabaseSchema_pgsql

Code

function renameTable($table, $new_name) {
  if (!$this->tableExists($table)) {
    throw new DatabaseSchemaObjectDoesNotExistException(t("Cannot rename %table to %table_new: table %table doesn't exist.", array('%table' => $table, '%table_new' => $new_name)));
  }
  if ($this->tableExists($new_name)) {
    throw new DatabaseSchemaObjectExistsException(t("Cannot rename %table to %table_new: table %table_new already exists.", array('%table' => $table, '%table_new' => $new_name)));
  }

  // Get the schema and tablename for the old table.
  $old_full_name = $this->connection->prefixTables('{' . $table . '}');
  list($old_schema, $old_table_name) = strpos($old_full_name, '.') ? explode('.', $old_full_name) : array('public', $old_full_name);

  // Index names and constraint names are global in PostgreSQL, so we need to
  // rename them when renaming the table.
  $indexes = $this->connection->query('SELECT indexname FROM pg_indexes WHERE schemaname = :schema AND tablename = :table', array(':schema' => $old_schema, ':table' => $old_table_name));
  foreach ($indexes as $index) {
    if (preg_match('/^' . preg_quote($old_full_name) . '_(.*)$/', $index->indexname, $matches)) {
      $index_name = $matches[1];
      $this->connection->query('ALTER INDEX ' . $index->indexname . ' RENAME TO {' . $new_name . '}_' . $index_name);
    }
  }

  // Now rename the table.
  // Ensure the new table name does not include schema syntax.
  $prefixInfo = $this->getPrefixInfo($new_name);
  $this->connection->query('ALTER TABLE {' . $table . '} RENAME TO ' . $prefixInfo['table']);
}