postgres.git / summary / log / commit / refs

commit    f604aa956d4f2540be4c3e7521045c98e6a70baa
Author:   Peter Eisentraut <peter@eisentraut.org>
Date:     Mon Apr 08 20:03:48 2019 +0000
First released in: 12.0, 10.8, 11.3

    doc: Update serial explanation
    
    The CREATE SEQUENCE command should include a data type specification,
    since PostgreSQL 10.
    
    Reported-by: mjf@pearson.co.uk


 doc/src/sgml/datatype.sgml | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml
index 6fdcc12661b..281fdb6d600 100644
--- a/doc/src/sgml/datatype.sgml
+++ b/doc/src/sgml/datatype.sgml
@@ -861,7 +861,7 @@ CREATE TABLE <replaceable class="parameter">tablename</replaceable> (
      is equivalent to specifying:
 
 <programlisting>
-CREATE SEQUENCE <replaceable class="parameter">tablename</replaceable>_<replaceable class="parameter">colname</replaceable>_seq;
+CREATE SEQUENCE <replaceable class="parameter">tablename</replaceable>_<replaceable class="parameter">colname</replaceable>_seq AS integer;
 CREATE TABLE <replaceable class="parameter">tablename</replaceable> (
     <replaceable class="parameter">colname</replaceable> integer NOT NULL DEFAULT nextval('<replaceable class="parameter">tablename</replaceable>_<replaceable class="parameter">colname</replaceable>_seq')
 );


[parent: b291488da513]