From a351192ec2a1306395e2563525969e8103fa3f5a Mon Sep 17 00:00:00 2001 From: Moritz Bunkus Date: Thu, 11 Feb 2021 11:01:23 +0100 Subject: [PATCH] OIDs von Tabellen entfernt --- sql/Pg-upgrade2/cape_remove_oids.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 sql/Pg-upgrade2/cape_remove_oids.sql diff --git a/sql/Pg-upgrade2/cape_remove_oids.sql b/sql/Pg-upgrade2/cape_remove_oids.sql new file mode 100644 index 000000000..b30d286d4 --- /dev/null +++ b/sql/Pg-upgrade2/cape_remove_oids.sql @@ -0,0 +1,9 @@ +-- @tag: cape_remove_oids +-- @description: OIDs von Tabellen entfernen +-- @depends: release_3_5_6 +ALTER TABLE assembly SET WITHOUT OIDS; +ALTER TABLE delivery_order_items SET WITHOUT OIDS; +ALTER TABLE invoice SET WITHOUT OIDS; +ALTER TABLE orderitems SET WITHOUT OIDS; +ALTER TABLE parts SET WITHOUT OIDS; +ALTER TABLE partsgroup SET WITHOUT OIDS; -- 2.20.1