function DatabaseSchema_pgsql::processField

Set database-engine specific properties for a field.

Parameters

$field: A field description array, as specified in the schema documentation.

File

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

Class

DatabaseSchema_pgsql

Code

protected function processField($field) {
    if (!isset($field['size'])) {
        $field['size'] = 'normal';
    }
    // Set the correct database-engine specific datatype.
    // In case one is already provided, force it to lowercase.
    if (isset($field['pgsql_type'])) {
        $field['pgsql_type'] = drupal_strtolower($field['pgsql_type']);
    }
    else {
        $map = $this->getFieldTypeMap();
        $field['pgsql_type'] = $map[$field['type'] . ':' . $field['size']];
    }
    if (!empty($field['unsigned'])) {
        // Unsigned datatypes are not supported in PostgreSQL 8.3. In MySQL,
        // they are used to ensure a positive number is inserted and it also
        // doubles the maximum integer size that can be stored in a field.
        // The PostgreSQL schema in Drupal creates a check constraint
        // to ensure that a value inserted is >= 0. To provide the extra
        // integer capacity, here, we bump up the column field size.
        if (!isset($map)) {
            $map = $this->getFieldTypeMap();
        }
        switch ($field['pgsql_type']) {
            case 'smallint':
                $field['pgsql_type'] = $map['int:medium'];
                break;
            case 'int':
                $field['pgsql_type'] = $map['int:big'];
                break;
        }
    }
    if (isset($field['type']) && $field['type'] == 'serial') {
        unset($field['not null']);
    }
    return $field;
}