From 853153ca6dfdf2bdf6ce800216de75b2fefbb4f1 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Fri, 6 Dec 2002 03:28:34 +0000 Subject: ALTER DOMAIN .. SET / DROP NOT NULL ALTER DOMAIN .. SET / DROP DEFAULT ALTER DOMAIN .. ADD / DROP CONSTRAINT New files: - doc/src/sgml/ref/alter_domain.sgml Rod Taylor --- doc/src/sgml/ref/allfiles.sgml | 3 +- doc/src/sgml/ref/alter_domain.sgml | 237 +++++++++++++++++++++++++++++++++++++ doc/src/sgml/reference.sgml | 3 +- 3 files changed, 241 insertions(+), 2 deletions(-) create mode 100644 doc/src/sgml/ref/alter_domain.sgml (limited to 'doc/src') diff --git a/doc/src/sgml/ref/allfiles.sgml b/doc/src/sgml/ref/allfiles.sgml index bd8c3e71f1f..9a06b19d4ee 100644 --- a/doc/src/sgml/ref/allfiles.sgml +++ b/doc/src/sgml/ref/allfiles.sgml @@ -1,5 +1,5 @@ @@ -38,6 +38,7 @@ Complete list of usable sgml source files in this directory. + diff --git a/doc/src/sgml/ref/alter_domain.sgml b/doc/src/sgml/ref/alter_domain.sgml new file mode 100644 index 00000000000..8c26e01706f --- /dev/null +++ b/doc/src/sgml/ref/alter_domain.sgml @@ -0,0 +1,237 @@ + + + + + ALTER DOMAIN + SQL - Language Statements + + + + ALTER DOMAIN + + + change the definition of a table + + + + + 2002-11-27 + + +ALTER DOMAIN domain + { SET DEFAULT value | DROP DEFAULT } +ALTER DOMAIN domain + { SET | DROP } NOT NULL +ALTER DOMAIN domain + ADD domain_constraint +ALTER DOMAIN domain + DROP CONSTRAINT constraint_name [ RESTRICT | CASCADE ] + + + + + 2002-11-27 + + + Inputs + + + + + + domain + + + The name (possibly schema-qualified) of an existing domain to + alter. + + + + + + domain_constraint + + + New domain constraint for the domain. + + + + + + constraint_name + + + Name of an existing constraint to drop. + + + + + + CASCADE + + + Automatically drop objects that depend constraint. + + + + + + RESTRICT + + + Refuse to drop the constraint if there are any dependent + objects. This is the default behavior. + + + + + + + + + + + 1998-04-15 + + + Outputs + + + + + + ALTER DOMAIN + + + Message returned from domain alteration. + + + + + + ERROR + + + Message returned if domain is not available. + + + + + + + + + + + 2002-11-27 + + + Description + + + ALTER DOMAIN changes the definition of an existing domain. + There are several sub-forms: + + + + + SET/DROP DEFAULT + + + These forms set or remove the default value for a column. Note + that defaults only apply to subsequent INSERT + commands; they do not cause rows already in a table using the domain. + + + + + + SET/DROP NOT NULL + + + These forms change whether a domain is marked to allow NULL + values or to reject NULL values. You may only SET NOT NULL + when the tables using the domain contain no null values in the domain + based column. + + + + + + ADD domain_constraint + + + This form adds a new constraint to a table using the same syntax as + . + + + + + + DROP CONSTRAINT + + + This form drops constraints on a domain. + + + + + + + + You must own the domain to use ALTER DOMAIN; except for + ALTER TABLE OWNER, which may only be executed by a superuser. + + + + + + Usage + + + To add a NOT NULL constraint to a column: + +ALTER DOMAIN zipcode SET NOT NULL; + + To remove a NOT NULL constraint from a column: + +ALTER DOMAIN zipcode DROP NOT NULL; + + + + + To add a check constraint to a table: + +ALTER DOMAIN zipcode ADD CONSTRAINT zipchk CHECK (char_length(VALUE) = 5); + + + + + To remove a check constraint from a table and all its children: + +ALTER DOMAIN zipcode DROP CONSTRAINT zipchk; + + + + + + + diff --git a/doc/src/sgml/reference.sgml b/doc/src/sgml/reference.sgml index 247ce8d8ce0..8709343c3c1 100644 --- a/doc/src/sgml/reference.sgml +++ b/doc/src/sgml/reference.sgml @@ -1,5 +1,5 @@ @@ -47,6 +47,7 @@ PostgreSQL Reference Manual &abort; &alterDatabase; + &alterDomain; &alterGroup; &alterTable; &alterTrigger; -- cgit v1.2.3