public function DatabaseSchema_pgsql::indexExists

Checks if an index exists in the given table.

Parameters

$table: The name of the table in drupal (no prefixing).

$name: The name of the index in drupal (no prefixing).

Return value

TRUE if the given index exists, otherwise FALSE.

Overrides DatabaseSchema::indexExists

2 calls to DatabaseSchema_pgsql::indexExists()
DatabaseSchema_pgsql::addIndex in drupal/includes/database/pgsql/schema.inc
Add an index.
DatabaseSchema_pgsql::dropIndex in drupal/includes/database/pgsql/schema.inc
Drop an index.

File

drupal/includes/database/pgsql/schema.inc, line 417
Database schema code for PostgreSQL database servers.

Class

DatabaseSchema_pgsql

Code

public function indexExists($table, $name) {

  // Details http://www.postgresql.org/docs/8.3/interactive/view-pg-indexes.html
  $index_name = '{' . $table . '}_' . $name . '_idx';
  return (bool) $this->connection
    ->query("SELECT 1 FROM pg_indexes WHERE indexname = '{$index_name}'")
    ->fetchField();
}