function DatabaseSchema_pgsql::renameTable
DatabaseSchema_pgsql::renameTable($table, $new_name)
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
- includes/database/pgsql/schema.inc, line 315
- Database schema code for PostgreSQL database servers.
Class
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']); }
© 2001–2016 by the original authors
Licensed under the GNU General Public License, version 2 and later.
Drupal is a registered trademark of Dries Buytaert.
https://api.drupal.org/api/drupal/includes!database!pgsql!schema.inc/function/DatabaseSchema_pgsql::renameTable/7.x