From 8aa705cea40dddfcab6a6e5f151b4e66b9a88814 Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Sun, 5 May 2013 13:21:52 +0200 Subject: [PATCH] Override id sequence name, since later Postgres versions have changed the naming. --- sql/pr0n.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/sql/pr0n.sql b/sql/pr0n.sql index fe749b9..b8fcf86 100644 --- a/sql/pr0n.sql +++ b/sql/pr0n.sql @@ -18,8 +18,10 @@ CREATE TABLE last_picture_cache ( FOREIGN KEY (vhost,event) REFERENCES events(vhost,event) ); +CREATE SEQUENCE imageid_seq; + CREATE TABLE images ( - id serial NOT NULL PRIMARY KEY, + id integer DEFAULT nextval('imageid_seq') NOT NULL PRIMARY KEY, vhost character varying NOT NULL, event character varying NOT NULL, filename character varying NOT NULL, -- 2.39.2