You are here

Home » API reference » Drupal 6 » database.pgsql.inc

function db_drop_unique_key in Drupal 6

Same name in this branch
  1. 6 includes/database.mysql-common.inc \db_drop_unique_key()
  2. 6 includes/database.pgsql.inc \db_drop_unique_key()
Same name and namespace in other branches
  1. 8 core/includes/database.inc \db_drop_unique_key()
  2. 7 includes/database/database.inc \db_drop_unique_key()

Drop a unique key.

Parameters

$ret: Array to which query results will be added.

$table: The table to be altered.

$name: The name of the key.

Related topics

Schema API
A Drupal schema definition is an array structure representing one or more tables and their related keys and indexes. A schema is defined by hook_schema(), which usually lives in a modulename.install file.
6 calls to db_drop_unique_key()
system_update_6005 in modules/system/system.install
Add language to url_alias table and modify indexes.
system_update_6019 in modules/system/system.install
Reconcile small differences in the previous, manually created mysql and pgsql schemas so they are the same and can be represented by a single schema structure.
system_update_6032 in modules/system/system.install
profile_fields.name used to be nullable but is part of a unique key and so shouldn't be.
system_update_6043 in modules/system/system.install
Update table indices to make them more rational and useful.
system_update_6044 in modules/system/system.install
RC1 to RC2 index cleanup.

... See full list

File

includes/database.pgsql.inc, line 796
Database interface code for PostgreSQL database servers.

Code

function db_drop_unique_key(&$ret, $table, $name) {
  $name = '{' . $table . '}_' . $name . '_key';
  $ret[] = update_sql('ALTER TABLE {' . $table . '} DROP CONSTRAINT ' . $name);
}