Beim Anlegen von Tabellen, die OIDs brauchen, explizit "WITH OIDS" mitgeben.

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.

diff --git a/sql/Pg-upgrade2/delivery_orders.sql b/sql/Pg-upgrade2/delivery_orders.sql
index 83a47e1f83626d739aa5060d2ccd06fb4a25d368..ba68b2fb6f25d02f94583a7a65a13f9008c20072 100644 (file)
--- 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)
   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();
 
 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 e57a683baf85863a1d70197d3ee4236ad9e2c6ec..12819196c02b167756e84a13a86be9fe55929074 100644 (file)
--- 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
     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
     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
     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
     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
     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
     partsgroup text,
     itime timestamp without time zone DEFAULT now(),
     mtime timestamp without time zone

-);
+) WITH OIDS;

 
 
 --
 
 
 --