dbscripts/help_users.sql

   1 UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" !~ '^pg_';
   2 \connect - postgres
   3 INSERT INTO "webdb_users" VALUES (1,'open','','f');
   4 INSERT INTO "webdb_users" VALUES (2,'redaktion','indymedia','t');
   5 INSERT INTO "webdb_users" VALUES (3,'tollendorf','indymedia','t');
   6 INSERT INTO "webdb_users" VALUES (4,'admin','indymedia','t');
   7 BEGIN TRANSACTION;
   8 CREATE TEMP TABLE "tr" ("tmp_relname" name, "tmp_reltriggers" smallint);
   9 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;
  10 UPDATE "pg_class" SET "reltriggers" = TMP."tmp_reltriggers" FROM "tr" TMP WHERE "pg_class"."relname" = TMP."tmp_relname";
  11 COMMIT TRANSACTION;