From 0f6e82efb2365d305e32d9ce5756133313b93303 Mon Sep 17 00:00:00 2001
From: Moritz Bunkus <m.bunkus@linet-services.de>
Date: Mon, 18 May 2009 14:31:37 +0000
Subject: [PATCH] Beim Anlegen von Tabellen, die OIDs brauchen, explizit "WITH
 OIDS" mitgeben.
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

Grund: PostgreSQL ab Version 8 legt OIDs normalerweise nicht automatisch
mit an, es sei denn, es ist in der Clusterkonfiguration explizit wieder
aktiviert worden.

Fix für Bug 941.
---
 sql/Pg-upgrade2/delivery_orders.sql |  2 +-
 sql/lx-office.sql                   | 12 ++++++------
 2 files changed, 7 insertions(+), 7 deletions(-)

diff --git a/sql/Pg-upgrade2/delivery_orders.sql b/sql/Pg-upgrade2/delivery_orders.sql
index 83a47e1f8..ba68b2fb6 100644
--- a/sql/Pg-upgrade2/delivery_orders.sql
+++ b/sql/Pg-upgrade2/delivery_orders.sql
@@ -75,7 +75,7 @@ CREATE TABLE delivery_order_items (
   FOREIGN KEY (parts_id)          REFERENCES parts (id),
   FOREIGN KEY (project_id)        REFERENCES project (id),
   FOREIGN KEY (price_factor_id)   REFERENCES price_factors (id)
-);
+) WITH OIDS;
 
 CREATE TRIGGER mtime_delivery_order_items_id BEFORE UPDATE ON delivery_order_items
     FOR EACH ROW EXECUTE PROCEDURE set_mtime();
diff --git a/sql/lx-office.sql b/sql/lx-office.sql
index e57a683ba..12819196c 100644
--- a/sql/lx-office.sql
+++ b/sql/lx-office.sql
@@ -142,7 +142,7 @@ CREATE TABLE parts (
     not_discountable boolean DEFAULT false,
     buchungsgruppen_id integer,
     payment_id integer
-);
+) WITH OIDS;
 
 
 --
@@ -216,7 +216,7 @@ CREATE TABLE acc_trans (
     taxkey integer,
     itime timestamp without time zone DEFAULT now(),
     mtime timestamp without time zone
-);
+) WITH OIDS;
 
 
 --
@@ -248,7 +248,7 @@ CREATE TABLE invoice (
     base_qty real,
     subtotal boolean DEFAULT false,
     longdescription text
-);
+) WITH OIDS;
 
 
 --
@@ -395,7 +395,7 @@ CREATE TABLE assembly (
     bom boolean,
     itime timestamp without time zone DEFAULT now(),
     mtime timestamp without time zone
-);
+) WITH OIDS;
 
 
 --
@@ -602,7 +602,7 @@ CREATE TABLE orderitems (
     base_qty real,
     subtotal boolean DEFAULT false,
     longdescription text
-);
+) WITH OIDS;
 
 
 --
@@ -694,7 +694,7 @@ CREATE TABLE partsgroup (
     partsgroup text,
     itime timestamp without time zone DEFAULT now(),
     mtime timestamp without time zone
-);
+) WITH OIDS;
 
 
 --
-- 
2.20.1