X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=dbscripts%2Fhelp_imglay.sql;h=07ffd3e3c1d8ddd6be1cdf00681a5e79de912cb9;hb=3c30bd159e17f3a760ea3995619c91ce1c7cd97d;hp=7da01487fc72bc4bbb42d667dc8c69c774038068;hpb=0ee7828e9bed6ad40415f6a7b76b1d484f985d86;p=mir.git

diff --git a/dbscripts/help_imglay.sql b/dbscripts/help_imglay.sql
index 7da01487..07ffd3e3 100755
--- a/dbscripts/help_imglay.sql
+++ b/dbscripts/help_imglay.sql
@@ -1,11 +1,7 @@
-UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" !~ '^pg_';
+
 -- \connect - postgres
 INSERT INTO "img_layout" VALUES (0,'--');
 INSERT INTO "img_layout" VALUES (1,'quer');
 INSERT INTO "img_layout" VALUES (2,'hoch');
 INSERT INTO "img_layout" VALUES (3,'quadrat');
-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;
+