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:07:18 +0200 |
| commit | dc92adc4bb8f3026a8eb70b297a8d6dd93e1166c (patch) | |
| tree | a4d16ec7126b39333984339e5108002785668adb | |
| parent | 1b5bbe4bcc912b070ad705ad7a79806692af18c8 (diff) | |
doc: Update serial explanation
The CREATE SEQUENCE command should include a data type specification,
since PostgreSQL 10.
Reported-by: mjf@pearson.co.uk
| -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 690e415e2c2..90e46ba035f 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') ); |