gnue/gnuef/samples/track/sql load.sql

[Jason Cater]

CVSROOT:        /home/cvs
Module name:    gnue
Changes by:     Jason Cater <address@hidden>    01/11/08 12:28:14

Modified files:
        gnuef/samples/track/sql: load.sql 

Log message:
        Fixed dneighno specific references

CVSWeb URLs:
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnuef/samples/track/sql/load.sql.diff?cvsroot=OldCVS&tr1=1.1&tr2=1.2&r1=text&r2=text

Patches:
Index: gnue/gnuef/samples/track/sql/load.sql
diff -u gnue/gnuef/samples/track/sql/load.sql:1.1 
gnue/gnuef/samples/track/sql/load.sql:1.2
--- gnue/gnuef/samples/track/sql/load.sql:1.1   Thu Mar 29 18:25:05 2001
+++ gnue/gnuef/samples/track/sql/load.sql       Thu Nov  8 12:28:14 2001
@@ -1,5 +1,3 @@
-UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" !~ '^pg_';
-\connect - dneighbo
 CREATE SEQUENCE "seq_address_id" start 1 increment 1 maxvalue 2147483647 
minvalue 1  cache 1 ;
 CREATE SEQUENCE "seq_address_type_id" start 1 increment 1 maxvalue 2147483647 
minvalue 1  cache 1 ;
 SELECT nextval ('"seq_address_type_id"');
@@ -49,8 +47,3 @@
 \.
 COPY "todo" FROM stdin;
 \.
-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;