[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
gnue/gnuef/samples/track/sql load.sql
From: |
Jason Cater |
Subject: |
gnue/gnuef/samples/track/sql load.sql |
Date: |
Thu, 08 Nov 2001 12:28:14 -0500 |
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;
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- gnue/gnuef/samples/track/sql load.sql,
Jason Cater <=