protected 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

Database schema code for PostgreSQL database servers.

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;
}