Revision 0f6e82ef
Von Moritz Bunkus vor fast 16 Jahren hinzugefügt
| sql/Pg-upgrade2/delivery_orders.sql | ||
|---|---|---|
|
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();
|
||
| sql/lx-office.sql | ||
|---|---|---|
|
not_discountable boolean DEFAULT false,
|
||
|
buchungsgruppen_id integer,
|
||
|
payment_id integer
|
||
|
);
|
||
|
) WITH OIDS;
|
||
|
|
||
|
|
||
|
--
|
||
| ... | ... | |
|
taxkey integer,
|
||
|
itime timestamp without time zone DEFAULT now(),
|
||
|
mtime timestamp without time zone
|
||
|
);
|
||
|
) WITH OIDS;
|
||
|
|
||
|
|
||
|
--
|
||
| ... | ... | |
|
base_qty real,
|
||
|
subtotal boolean DEFAULT false,
|
||
|
longdescription text
|
||
|
);
|
||
|
) WITH OIDS;
|
||
|
|
||
|
|
||
|
--
|
||
| ... | ... | |
|
bom boolean,
|
||
|
itime timestamp without time zone DEFAULT now(),
|
||
|
mtime timestamp without time zone
|
||
|
);
|
||
|
) WITH OIDS;
|
||
|
|
||
|
|
||
|
--
|
||
| ... | ... | |
|
base_qty real,
|
||
|
subtotal boolean DEFAULT false,
|
||
|
longdescription text
|
||
|
);
|
||
|
) WITH OIDS;
|
||
|
|
||
|
|
||
|
--
|
||
| ... | ... | |
|
partsgroup text,
|
||
|
itime timestamp without time zone DEFAULT now(),
|
||
|
mtime timestamp without time zone
|
||
|
);
|
||
|
) WITH OIDS;
|
||
|
|
||
|
|
||
|
--
|
||
Auch abrufbar als: Unified diff
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.