basher
12/28/2020, 12:01 AMCREATE TABLE SchemaVersion (
id INT PRIMARY KEY NOT NULL,
version INT NOT NULL
);
setVersion:
INSERT INTO SchemaVersion(id, version) VALUES (0, ?)
ON CONFLICT (id) DO UPDATE SET version = excluded.version;
Instead, I get
line 8:0 - ',' or RETURNING expected, got 'ON'
7 INSERT INTO SchemaVersion(id, version) VALUES (0, 'test')
8 ON CONFLICT (id) DO UPDATE SET version = excluded.version
basher
12/28/2020, 12:02 AMbasher
12/28/2020, 12:02 AMjw
12/28/2020, 12:04 AMbasher
12/28/2020, 12:05 AMbasher
12/28/2020, 12:07 AM