Skip to content

Commit 839cea8

Browse files
committed
Minor copy-editing.
1 parent a9c1ff6 commit 839cea8

File tree

1 file changed

+13
-11
lines changed

1 file changed

+13
-11
lines changed

doc/src/sgml/datatype.sgml

Lines changed: 13 additions & 11 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/datatype.sgml,v 1.125 2003/10/09 19:13:48 momjian Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/datatype.sgml,v 1.126 2003/10/16 04:52:21 tgl Exp $
33
-->
44

55
<chapter id="datatype">
@@ -682,7 +682,7 @@ NUMERIC
682682
<para>
683683
The data types <type>serial</type> and <type>bigserial</type>
684684
are not true types, but merely
685-
a notational convenience for setting up identifier columns
685+
a notational convenience for setting up unique identifier columns
686686
(similar to the <literal>AUTO_INCREMENT</literal> property
687687
supported by some other databases). In the current
688688
implementation, specifying
@@ -722,10 +722,10 @@ CREATE TABLE <replaceable class="parameter">tablename</replaceable> (
722722
</note>
723723

724724
<para>
725-
To use a <type>serial</type> column to insert the next value of
726-
the sequence into the table, specify that the <type>serial</type>
727-
column should be assigned the default value. This can be done
728-
either be excluding from the column from the list of columns in
725+
To insert the next value of the sequence into the <type>serial</type>
726+
column, specify that the <type>serial</type>
727+
column should be assigned its default value. This can be done
728+
either by excluding the column from the list of columns in
729729
the <command>INSERT</command> statement, or through the use of
730730
the <literal>DEFAULT</literal> keyword.
731731
</para>
@@ -741,8 +741,8 @@ CREATE TABLE <replaceable class="parameter">tablename</replaceable> (
741741
</para>
742742

743743
<para>
744-
The sequence created by a <type>serial</type> type is
745-
automatically dropped when the owning column is dropped and
744+
The sequence created for a <type>serial</type> column is
745+
automatically dropped when the owning column is dropped, and
746746
cannot be dropped otherwise. (This was not true in
747747
<productname>PostgreSQL</productname> releases before 7.3. Note
748748
that this automatic drop linkage will not occur for a sequence
@@ -751,9 +751,11 @@ CREATE TABLE <replaceable class="parameter">tablename</replaceable> (
751751
dependency link.) Furthermore, this dependency between sequence
752752
and column is made only for the <type>serial</> column itself; if
753753
any other columns reference the sequence (perhaps by manually
754-
calling the <function>nextval</>) function), they may be broken
755-
if the sequence is removed. Using <type>serial</> columns in
756-
fashion is considered bad form.
754+
calling the <function>nextval</> function), they will be broken
755+
if the sequence is removed. Using a <type>serial</> column's sequence
756+
in such a fashion is considered bad form; if you wish to feed several
757+
columns from the same sequence generator, create the sequence as an
758+
independent object.
757759
</para>
758760
</sect2>
759761
</sect1>

0 commit comments

Comments
 (0)