Revision 0f6e82ef
Von Moritz Bunkus vor mehr als 15 Jahren hinzugefügt
| sql/Pg-upgrade2/delivery_orders.sql | ||
|---|---|---|
| 75 | 75 |
FOREIGN KEY (parts_id) REFERENCES parts (id), |
| 76 | 76 |
FOREIGN KEY (project_id) REFERENCES project (id), |
| 77 | 77 |
FOREIGN KEY (price_factor_id) REFERENCES price_factors (id) |
| 78 |
); |
|
| 78 |
) WITH OIDS;
|
|
| 79 | 79 |
|
| 80 | 80 |
CREATE TRIGGER mtime_delivery_order_items_id BEFORE UPDATE ON delivery_order_items |
| 81 | 81 |
FOR EACH ROW EXECUTE PROCEDURE set_mtime(); |
| sql/lx-office.sql | ||
|---|---|---|
| 142 | 142 |
not_discountable boolean DEFAULT false, |
| 143 | 143 |
buchungsgruppen_id integer, |
| 144 | 144 |
payment_id integer |
| 145 |
); |
|
| 145 |
) WITH OIDS;
|
|
| 146 | 146 |
|
| 147 | 147 |
|
| 148 | 148 |
-- |
| ... | ... | |
| 216 | 216 |
taxkey integer, |
| 217 | 217 |
itime timestamp without time zone DEFAULT now(), |
| 218 | 218 |
mtime timestamp without time zone |
| 219 |
); |
|
| 219 |
) WITH OIDS;
|
|
| 220 | 220 |
|
| 221 | 221 |
|
| 222 | 222 |
-- |
| ... | ... | |
| 248 | 248 |
base_qty real, |
| 249 | 249 |
subtotal boolean DEFAULT false, |
| 250 | 250 |
longdescription text |
| 251 |
); |
|
| 251 |
) WITH OIDS;
|
|
| 252 | 252 |
|
| 253 | 253 |
|
| 254 | 254 |
-- |
| ... | ... | |
| 395 | 395 |
bom boolean, |
| 396 | 396 |
itime timestamp without time zone DEFAULT now(), |
| 397 | 397 |
mtime timestamp without time zone |
| 398 |
); |
|
| 398 |
) WITH OIDS;
|
|
| 399 | 399 |
|
| 400 | 400 |
|
| 401 | 401 |
-- |
| ... | ... | |
| 602 | 602 |
base_qty real, |
| 603 | 603 |
subtotal boolean DEFAULT false, |
| 604 | 604 |
longdescription text |
| 605 |
); |
|
| 605 |
) WITH OIDS;
|
|
| 606 | 606 |
|
| 607 | 607 |
|
| 608 | 608 |
-- |
| ... | ... | |
| 694 | 694 |
partsgroup text, |
| 695 | 695 |
itime timestamp without time zone DEFAULT now(), |
| 696 | 696 |
mtime timestamp without time zone |
| 697 |
); |
|
| 697 |
) WITH OIDS;
|
|
| 698 | 698 |
|
| 699 | 699 |
|
| 700 | 700 |
-- |
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.