From b9cd4c83314fb4555163ad1b12c940ab01cffcad Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Tue, 30 Oct 2001 20:13:44 +0000 Subject: [PATCH] Grammatical corrections. --- doc/src/sgml/datatype.sgml | 17 +++++++++++------ 1 file changed, 11 insertions(+), 6 deletions(-) diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index 7c3ba40363..42f49d2ea7 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -1,5 +1,5 @@ @@ -623,6 +623,10 @@ NUMERIC serial + + bigserial + + serial4 @@ -679,14 +683,14 @@ CREATE TABLE tablename ( The type names serial and serial4 are equivalent: both create integer columns. The type - names bigserial and serial8 works just - the same way, except that it creates a bigint - column. serial8 should be used if you anticipate + names bigserial and serial8 work just + the same way, except that they create a bigint + column. bigserial should be used if you anticipate use of more than 2^31 identifiers over the lifetime of the table. - Implicit sequences supporting the serial are + Implicit sequences supporting the serial types are not automatically dropped when a table containing a serial type is dropped. So, the following commands executed in order will likely fail: @@ -697,7 +701,8 @@ CREATE TABLE tablename ( The sequence will remain in the database until explicitly dropped using - DROP SEQUENCE. + DROP SEQUENCE. (This annoyance will probably be + changed in some future release.) -- 2.40.0