function DatabaseSchema_pgsql::constraintExists

Helper function: check if a constraint (PK, FK, UK) exists.

Parameters

$table: The name of the table.

$name: The name of the constraint (typically 'pkey' or '[constraint]_key').

File

includes/database/pgsql/schema.inc, line 627

Class

DatabaseSchema_pgsql

Code

protected function constraintExists($table, $name) {
    // ensureIdentifiersLength() expects three parameters, thus we split our
    // constraint name in a proper name and a suffix.
    if ($name == 'pkey') {
        $suffix = $name;
        $name = '';
    }
    else {
        $pos = strrpos($name, '_');
        $suffix = substr($name, $pos + 1);
        $name = substr($name, 0, $pos);
    }
    $constraint_name = $this->ensureIdentifiersLength($table, $name, $suffix);
    return (bool) $this->connection
        ->query("SELECT 1 FROM pg_constraint WHERE conname = '{$constraint_name}'")
        ->fetchField();
}