X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=dbscripts%2Fhelp_lang.sql;h=6cf6a0b2e433c402cab8f553ad7e0043cd6135d8;hb=04f496715d73dda64a64c424bb830d80fc592817;hp=ca3356c3f7a59fefa3d28bea6f906e14116c0f8e;hpb=0f1d06080db7839f70140e6aead274dcabfe8fc3;p=mir.git

diff --git a/dbscripts/help_lang.sql b/dbscripts/help_lang.sql
index ca3356c3..6cf6a0b2 100755
--- a/dbscripts/help_lang.sql
+++ b/dbscripts/help_lang.sql
@@ -1,9 +1,4 @@
-UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" !~ '^pg_';
-\connect - postgres
+
+-- \connect - postgres
 INSERT INTO "language" VALUES (0,'deutsch','de');
 INSERT INTO "language" VALUES (1,'english','en');
-BEGIN TRANSACTION;
-CREATE TEMP TABLE "tr" ("tmp_relname" name, "tmp_reltriggers" smallint);
-INSERT INTO "tr" SELECT C."relname", count(T."oid") FROM "pg_class" C, "pg_trigger" T WHERE C."oid" = T."tgrelid" AND C."relname" !~ '^pg_' GROUP BY 1;
-UPDATE "pg_class" SET "reltriggers" = TMP."tmp_reltriggers" FROM "tr" TMP WHERE "pg_class"."relname" = TMP."tmp_relname";
-COMMIT TRANSACTION;