Project

General

Profile

« Previous | Next » 

Revision 8846

Added by Jing Tao over 9 years ago

Add the code to delete the records in the xml_accesssubtree table.

View differences:

delete_all_by_pid.sql
32 32 
		DELETE FROM xml_index WHERE docid = v_docid;
33 33 
		GET DIAGNOSTICS deleted_count = ROW_COUNT;
34 34 
		RAISE NOTICE 'Deleted % rows from xml_index', deleted_count;
35 

  		




  
  36
  
    
                DELETE FROM xml_accesssubtree WHERE docid = v_docid;


  		




  
  37
  
    
                GET DIAGNOSTICS deleted_count = ROW_COUNT;


  		




  
  38
  
    
                RAISE NOTICE 'Deleted % rows from xml_accesssubtree', deleted_count;


  		




  35
  39
  
    
	


  		




  36
  40
  
    
		DELETE FROM xml_documents WHERE docid = v_docid AND rev = v_rev;


  		




  37
  41
  
    
		GET DIAGNOSTICS deleted_count = ROW_COUNT;


  		




  ......




  115
  119
  
    
--ROLLBACK;


  		




  116
  120
  
    
COMMIT;


  		




  117
  121
  
    
-- Clean up


  		




  118
  
  
    
DROP TABLE pids_to_delete;


  		




  
  122
  
    
DROP TABLE pids_to_delete;


  		












Also available in:  Unified diff