Make sure to limit identifiers according to PostgreSQL compiled in length.

PostgreSQL allows in standard configuration identifiers no longer than 63 chars for table/relation names, indexes, primary keys, and constraints. So we map all identifiers that are too long to drupal_base64hash_tag, where tag is one of:

• idx for indexes
• key for constraints
• pkey for primary keys
• seq for sequences

Parameters

string $table_identifier_part: The first argument used to build the identifier string. This usually refers to a table/relation name.

string $column_identifier_part: The second argument used to build the identifier string. This usually refers to one or more column names.

string $tag: The identifier tag. It can be one of 'idx', 'key', 'pkey' or 'seq'.

Return value

string The index/constraint/pkey identifier.

10 calls to DatabaseSchema_pgsql::ensureIdentifiersLength()

DatabaseSchema_pgsql::addPrimaryKey in includes/database/pgsql/schema.inc

Add a primary key.

DatabaseSchema_pgsql::addUniqueKey in includes/database/pgsql/schema.inc

Add a unique key.

DatabaseSchema_pgsql::constraintExists in includes/database/pgsql/schema.inc

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

DatabaseSchema_pgsql::createTableSql in includes/database/pgsql/schema.inc

Generate SQL to create a new table from a Drupal schema definition.

DatabaseSchema_pgsql::dropIndex in includes/database/pgsql/schema.inc

Drop an index.

... See full list

File

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

Class

DatabaseSchema_pgsql

Code

protected function ensureIdentifiersLength($table_identifier_part, $column_identifier_part, $tag) {
    $info = $this->getPrefixInfo($table_identifier_part);
    $table_identifier_part = $info['table'];
    // Filters out potentially empty $column_identifier_part to ensure
    // compatibility with old naming convention (see prefixNonTable()).
    $identifiers = array_filter(array(
        $table_identifier_part,
        $column_identifier_part,
        $tag,
    ));
    $identifierName = implode('_', $identifiers);
    // Retrieve the max identifier length which is usually 63 characters
    // but can be altered before PostgreSQL is compiled so we need to check.
    if (empty($this->maxIdentifierLength)) {
        $this->maxIdentifierLength = $this->connection
            ->query("SHOW max_identifier_length")
            ->fetchField();
    }
    if (strlen($identifierName) > $this->maxIdentifierLength) {
        $saveIdentifier = 'drupal_' . $this->hashBase64($identifierName) . '_' . $tag;
    }
    else {
        $saveIdentifier = $identifierName;
    }
    return $saveIdentifier;
}

---