public function DatabaseSchema_pgsql::fieldSetDefault

public DatabaseSchema_pgsql::fieldSetDefault($table, $field, $default)

Set the default value for a field.

Parameters

$table: The table to be altered.

$field: The field to be altered.

$default: Default value to be set. NULL for 'default NULL'.

Throws

DatabaseSchemaObjectDoesNotExistException If the specified table or field doesn't exist.

Overrides DatabaseSchema::fieldSetDefault

File

includes/database/pgsql/schema.inc, line 394
Database schema code for PostgreSQL database servers.

Class

DatabaseSchema_pgsql

Code

public function fieldSetDefault($table, $field, $default) {
  if (!$this->fieldExists($table, $field)) {
    throw new DatabaseSchemaObjectDoesNotExistException(t("Cannot set default value of field @table.@field: field doesn't exist.", array('@table' => $table, '@field' => $field)));
  }

  if (!isset($default)) {
    $default = 'NULL';
  }
  else {
    $default = is_string($default) ? "'$default'" : $default;
  }

  $this->connection->query('ALTER TABLE {' . $table . '} ALTER COLUMN "' . $field . '" SET DEFAULT ' . $default);
}

© 2001–2016 by the original authors
Licensed under the GNU General Public License, version 2 and later.
Drupal is a registered trademark of Dries Buytaert.
https://api.drupal.org/api/drupal/includes!database!pgsql!schema.inc/function/DatabaseSchema_pgsql::fieldSetDefault/7.x