[gbif-cvs] portal-index/db process.sql,1.23,1.24

[Jose C. <jos...@us...>]

Update of /cvsroot/gbif/portal-index/db
In directory ddv4jf1.ch3.sourceforge.com:/tmp/cvs-serv15447/db

Modified Files:
	process.sql 
Log Message:
added update statement to eliminate infinite loops in the taxonomy (taxon concept having a parent with a higher or same rank)

Index: process.sql
===================================================================
RCS file: /cvsroot/gbif/portal-index/db/process.sql,v
retrieving revision 1.23
retrieving revision 1.24
diff -C2 -d -r1.23 -r1.24
*** process.sql	7 May 2009 14:29:45 -0000	1.23
--- process.sql	26 May 2009 09:39:31 -0000	1.24
***************
*** 609,611 ****
--- 609,617 ----
  group by 2;
  
+ -- to eliminate possiblity of infinites loops in the taxonomy
+ update taxon_concept c
+ inner join taxon_concept p on c.parent_concept_id=p.id
+ set c.parent_concept_id=null
+ where p.rank>=c.rank
+ 
  select concat('Rollover complete: ', now()) as debug;