Hello,
I try to upgrade 5.29 to 5.35.2 and get the same error
{“error”: “migration failed: syntax error at or near “NOT” (column 33) in line 25: CREATE TABLE IF NOT EXISTS teams (\n id VARCHAR(26) PRIMARY KEY,\n createat bigint,\n updateat bigint,\n deleteat bigint,\n displayname VARCHAR(64),\n name VARCHAR(64),\n description VARCHAR(255),\n email VARCHAR(128),\n type VARCHAR(255),\n companyname VARCHAR(64),\n alloweddomains VARCHAR(1000),\n inviteid VARCHAR(32),\n schemeid VARCHAR(26),\n UNIQUE(name)\n);\n\nCREATE INDEX IF NOT EXISTS idx_teams_name ON teams (name) ;\nCREATE INDEX IF NOT EXISTS idx_teams_invite_id ON teams (inviteid);\nCREATE INDEX IF NOT EXISTS idx_teams_update_at ON teams (updateat);\nCREATE INDEX IF NOT EXISTS idx_teams_create_at ON teams (createat);\nCREATE INDEX IF NOT EXISTS idx_teams_delete_at ON teams (deleteat);\nCREATE INDEX IF NOT EXISTS idx_teams_scheme_id ON teams (schemeid);\n\nALTER TABLE teams ADD COLUMN IF NOT EXISTS allowopeninvite boolean;\nALTER TABLE teams ADD COLUMN IF NOT EXISTS lastteamiconupdate bigint;\nALTER TABLE teams ADD COLUMN IF NOT EXISTS description VARCHAR(255);\nALTER TABLE teams ADD COLUMN IF NOT EXISTS groupconstrained boolean;\n (details: pq: syntax error at or near “NOT”)”}
My postgres version psql (PostgreSQL) 9.5.24
Is needed upgrading postgree to v10 version?