[Lxr-commits] CVS: lxr/templates/initdb initdb-m-template.sql, 1.4, 1.5

[Andre-Littoz <ajl...@us...>]

Update of /cvsroot/lxr/lxr/templates/initdb
In directory sfp-cvs-1.v30.ch3.sourceforge.com:/tmp/cvs-serv16021/templates/initdb

Modified Files:
	initdb-m-template.sql 
Log Message:
templates/initdb/initdb-m-template.sql: manage "relation" reference count directly from SQL trigger instead of from Perl programming; remove an unnecessary index

Index: initdb-m-template.sql
===================================================================
RCS file: /cvsroot/lxr/lxr/templates/initdb/initdb-m-template.sql,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- initdb-m-template.sql	21 Jan 2013 16:35:04 -0000	1.4
+++ initdb-m-template.sql	17 Nov 2013 09:28:36 -0000	1.5
@@ -278,7 +278,6 @@
 	, constraint %DB_tbl_prefix%fk_defn_fileid
 		foreign key (fileid)
 		references %DB_tbl_prefix%files(fileid)
-	, index (typeid, langid)
 	, constraint %DB_tbl_prefix%fk_defn_type
 		foreign key (typeid, langid)
 		references %DB_tbl_prefix%langtypes(typeid, langid)
@@ -291,11 +290,18 @@
 /* The following trigger maintains correct symbol reference count
  * after definition deletion.
  */
+delimiter //
 drop trigger if exists %DB_tbl_prefix%remove_definition;
 create trigger %DB_tbl_prefix%remove_definition
 	after delete on %DB_tbl_prefix%definitions
 	for each row
-	call %DB_tbl_prefix%decsym(old.symid);
+	begin
+		call %DB_tbl_prefix%decsym(old.symid);
+		if old.relid is not null
+		then call %DB_tbl_prefix%decsym(old.relid);
+		end if;
+	end//
+delimiter ;
 
 /* Usages */
 create table %DB_tbl_prefix%usages