summaryrefslogtreecommitdiffstats
path: root/upgrades/dbpatches/1.4/postgresql/patch/services.sql
diff options
context:
space:
mode:
Diffstat (limited to 'upgrades/dbpatches/1.4/postgresql/patch/services.sql')
-rw-r--r--upgrades/dbpatches/1.4/postgresql/patch/services.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/upgrades/dbpatches/1.4/postgresql/patch/services.sql b/upgrades/dbpatches/1.4/postgresql/patch/services.sql
index efafc4e5..3a26b069 100644
--- a/upgrades/dbpatches/1.4/postgresql/patch/services.sql
+++ b/upgrades/dbpatches/1.4/postgresql/patch/services.sql
@@ -8,7 +8,7 @@ CREATE TABLE services_tmp (
goodsla numeric(5,2) DEFAULT '99.9' NOT NULL,
sortorder integer DEFAULT '0' NOT NULL,
PRIMARY KEY (serviceid)
-);
+) with OIDS;
insert into services_tmp select * from services;
drop table services;