aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorAndrew Dunstan <andrew@dunslane.net>2010-11-16 22:18:33 -0500
committerAndrew Dunstan <andrew@dunslane.net>2010-11-16 22:18:33 -0500
commitb7fcf68e8632e757a50352c9567bb630ed285201 (patch)
tree826bccd9f8fcdba6b0d7f49b690ce81f4c5457cd /doc/src
parent4acf99b2f3bb665d2febef183ede5f08b8f7545d (diff)
downloadpostgresql-b7fcf68e8632e757a50352c9567bb630ed285201.tar.gz
postgresql-b7fcf68e8632e757a50352c9567bb630ed285201.zip
Require VALUE keyword when extending an enum type. Based on a patch from Alvaro Herrera.
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/ref/alter_type.sgml8
1 files changed, 4 insertions, 4 deletions
diff --git a/doc/src/sgml/ref/alter_type.sgml b/doc/src/sgml/ref/alter_type.sgml
index 90de2e81ef8..33413450c37 100644
--- a/doc/src/sgml/ref/alter_type.sgml
+++ b/doc/src/sgml/ref/alter_type.sgml
@@ -28,7 +28,7 @@ ALTER TYPE <replaceable class="PARAMETER">name</replaceable> OWNER TO <replaceab
ALTER TYPE <replaceable class="PARAMETER">name</replaceable> RENAME ATTRIBUTE <replaceable class="PARAMETER">attribute_name</replaceable> TO <replaceable class="PARAMETER">new_attribute_name</replaceable>
ALTER TYPE <replaceable class="PARAMETER">name</replaceable> RENAME TO <replaceable class="PARAMETER">new_name</replaceable>
ALTER TYPE <replaceable class="PARAMETER">name</replaceable> SET SCHEMA <replaceable class="PARAMETER">new_schema</replaceable>
-ALTER TYPE <replaceable class="PARAMETER">name</replaceable> ADD <replaceable class="PARAMETER">new_enum_value</replaceable> [ { BEFORE | AFTER } <replaceable class="PARAMETER">existing_enum_value</replaceable> ]
+ALTER TYPE <replaceable class="PARAMETER">name</replaceable> ADD VALUE <replaceable class="PARAMETER">new_enum_value</replaceable> [ { BEFORE | AFTER } <replaceable class="PARAMETER">existing_enum_value</replaceable> ]
<phrase>where <replaceable class="PARAMETER">action</replaceable> is one of:</phrase>
@@ -106,7 +106,7 @@ ALTER TYPE <replaceable class="PARAMETER">name</replaceable> ADD <replaceable cl
</varlistentry>
<varlistentry>
- <term><literal>ADD [ BEFORE | AFTER ]</literal></term>
+ <term><literal>ADD VALUE [ BEFORE | AFTER ]</literal></term>
<listitem>
<para>
This form adds a new value to an enum type. If the new value's place in
@@ -238,7 +238,7 @@ ALTER TYPE <replaceable class="PARAMETER">name</replaceable> ADD <replaceable cl
<title>Notes</title>
<para>
- <command>ALTER TYPE ... ADD</> (the form that adds a new value to an
+ <command>ALTER TYPE ... ADD VALUE</> (the form that adds a new value to an
enum type) cannot be executed inside a transaction block.
</para>
@@ -292,7 +292,7 @@ ALTER TYPE compfoo ADD ATTRIBUTE f3 int;
<para>
To add a new value to an enum type in a particular sort position:
<programlisting>
-ALTER TYPE colors ADD 'orange' AFTER 'red';
+ALTER TYPE colors ADD VALUE 'orange' AFTER 'red';
</programlisting>
</para>
</refsect1>