From 347b8aa582998cdf49341a4ac61a25cb4a41e8ea Mon Sep 17 00:00:00 2001 From: Mischa POSLAWSKY Date: Mon, 24 Oct 2022 00:29:26 +0200 Subject: [PATCH] word: declare postgresql sequences as identities --- tools/word.pg.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/tools/word.pg.sql b/tools/word.pg.sql index 9f6bd41..7f97ada 100644 --- a/tools/word.pg.sql +++ b/tools/word.pg.sql @@ -4,7 +4,7 @@ CREATE TABLE login ( email text, fullname text, editlang text[], - id serial NOT NULL PRIMARY KEY + id integer NOT NULL PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY ); CREATE TABLE word ( @@ -24,7 +24,7 @@ CREATE TABLE word ( creator integer REFERENCES login (id), created timestamptz DEFAULT now(), updated timestamptz, - id serial NOT NULL PRIMARY KEY + id integer NOT NULL PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY ); COMMENT ON COLUMN word.form IS 'preferred textual representation'; @@ -49,7 +49,7 @@ CREATE TABLE kind ( creator integer REFERENCES login (id), created timestamptz DEFAULT now(), updated timestamptz, - id serial NOT NULL PRIMARY KEY + id integer NOT NULL PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY ); COMMENT ON COLUMN kind.truth IS 'link validity ranging from 0 (never) to 100 (always)'; -- 2.30.0