Project

General

Profile

« Previous | Next » 

Revision 6532

Added by Aaron Marcuse-Kubitza almost 12 years ago

schemas/vegbien.sql: sync_analytical_*_to_view(): Creating analytical_* table: Fixed bug where need LIMIT 0 so that it can be used on a full DB, which will have data in the tables used by analytical_stem_view

View differences:

vegbien.sql
906 906 
    LANGUAGE sql
907 907 
    AS $$
908 908 
DROP TABLE IF EXISTS analytical_aggregate;
909 
CREATE TABLE analytical_aggregate AS SELECT * FROM analytical_aggregate_view;
909 
CREATE TABLE analytical_aggregate AS SELECT * FROM analytical_aggregate_view LIMIT 0;
910 910 

  		




  911
  911
  
    
ALTER TABLE analytical_aggregate ALTER COLUMN "institutionCode" SET NOT NULL;


  		




  912
  912
  
    
ALTER TABLE analytical_aggregate ALTER COLUMN "plotName" SET NOT NULL;


  		




  ......




  923
  923
  
    
    LANGUAGE sql


  		




  924
  924
  
    
    AS $$


  		




  925
  925
  
    
DROP TABLE IF EXISTS analytical_stem;


  		




  926
  
  
    
CREATE TABLE analytical_stem AS SELECT * FROM analytical_stem_view;


  		




  
  926
  
    
CREATE TABLE analytical_stem AS SELECT * FROM analytical_stem_view LIMIT 0;


  		




  927
  927
  
    

  		




  928
  928
  
    
ALTER TABLE analytical_stem ALTER COLUMN "institutionCode" SET NOT NULL;


  		




  929
  929
  
    
ALTER TABLE analytical_stem ALTER COLUMN "plotName" SET NOT NULL;


  		












Also available in:  Unified diff