added better support for article urls in PDF files

[mir.git] / dbscripts / help_imgcolor.sql

diff --git a/dbscripts/help_imgcolor.sql b/dbscripts/help_imgcolor.sql
index 1f28846..5e04ecb 100755 (executable)
--- a/dbscripts/help_imgcolor.sql
+++ b/dbscripts/help_imgcolor.sql
@@ -1,12 +1,8 @@
-UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" !~ '^pg_';
+
 -- \connect - postgres
 INSERT INTO "img_color" VALUES (0,'--');
 INSERT INTO "img_color" VALUES (3,'color (16)');
 INSERT INTO "img_color" VALUES (4,'color (256)');
 INSERT INTO "img_color" VALUES (1,'b/w');
 INSERT INTO "img_color" VALUES (2,'color');
-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;
+