X-Git-Url: http://erislabs.net/gitweb/?a=blobdiff_plain;f=dbscripts%2Fhelp_arttype.sql;h=0bdad5e73412da8534ea596d2bd899144c2d5c79;hb=19ebec3112b470418500582acbaa10a0878d7bc8;hp=02fd99d20daaedf81af6aa05e4d80c9e8a7c8ad8;hpb=c7dbc101c5a3b87768cededc5938b98c4ebfcd4d;p=mir.git

diff --git a/dbscripts/help_arttype.sql b/dbscripts/help_arttype.sql
index 02fd99d2..0bdad5e7 100755
--- a/dbscripts/help_arttype.sql
+++ b/dbscripts/help_arttype.sql
@@ -1,12 +1,7 @@
-UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" !~ '^pg_';
 -- \connect - postgres
 INSERT INTO "article_type" VALUES (0,'openposting');
 INSERT INTO "article_type" VALUES (1,'newswire');
 INSERT INTO "article_type" VALUES (2,'feature');
 INSERT INTO "article_type" VALUES (3,'topicspecial');
 INSERT INTO "article_type" VALUES (4,'startspecial');
-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;
+INSERT INTO "article_type" VALUES (5,'translation');