Skip to content
This repository has been archived by the owner on Apr 18, 2024. It is now read-only.

v1.7.0

Compare
Choose a tag to compare
@ostark ostark released this 08 Feb 21:25
adds uid_urlhash_idx on installation to support

without this Postgres will complain that "ERROR:  there is no unique or exclusion constraint matching the ON CONFLICT specification" with the following SQL,

INSERT INTO "upper_cache" ("urlHash", "url", "tags", "headers", "siteId", "dateCreated", "dateUpdated", "uid") VALUES ($1, $2, ARRAY[]::varchar[], $3, $4, $5, $6, $7) ON CONFLICT ("uid", "urlHash") DO UPDATE SET "urlHash"=$8, "url"=$9, "tags"=ARRAY[]::varchar[], "headers"=$10, "siteId"=$11, "dateCreated"=$12, "dateUpdated"=$13, "uid"=$14