diff options
| author | Peter Eisentraut <peter@eisentraut.org> | 2019-04-08 22:03:48 +0200 |
|---|---|---|
| committer | Peter Eisentraut <peter@eisentraut.org> | 2019-04-08 22:03:48 +0200 |
| commit | c66000385fe1dc94a6d5525dcd192f17b551fb9b (patch) | |
| tree | a0cf57e21d8e91ca9cca6c1fd160f6c170d83423 /doc/src | |
| parent | a8cb8f124679e0c373fdd07108b136e1cf1ee14a (diff) | |
| download | postgresql-c66000385fe1dc94a6d5525dcd192f17b551fb9b.tar.gz postgresql-c66000385fe1dc94a6d5525dcd192f17b551fb9b.zip | |
doc: Update serial explanation
The CREATE SEQUENCE command should include a data type specification,
since PostgreSQL 10.
Reported-by: mjf@pearson.co.uk
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/datatype.sgml | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index cced57b2a83..13b988077a5 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -880,7 +880,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') ); |