public function DatabaseSchema_pgsql::indexExists

7.x schema.inc public DatabaseSchema_pgsql::indexExists($table, $name)

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-7.x/includes/database/pgsql/schema.inc: Add an index.
DatabaseSchema_pgsql::dropIndex in drupal-7.x/includes/database/pgsql/schema.inc: Drop an index.

File

drupal-7.x/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();
}