Project

General

Profile

« Previous | Next » 

Revision 13602

Added by Aaron Marcuse-Kubitza over 10 years ago

bugfix: schemas/public_.sql: sync_geoscrub_input_to_view(): `CREATE TABLE geoscrub_input AS __`: needs `LIMIT 0`

View differences:

trunk/schemas/public_.sql
2844 2844 
    LANGUAGE sql
2845 2845 
    AS $$
2846 2846 
DROP TABLE IF EXISTS geoscrub_input;
2847 
CREATE TABLE geoscrub_input AS SELECT * FROM geoscrub_input_view;
2847 
CREATE TABLE geoscrub_input AS SELECT * FROM geoscrub_input_view LIMIT 0;
2848 2848 

  		




  2849
  2849
  
    
GRANT SELECT ON TABLE geoscrub_input TO bien_read;


  		




  2850
  2850
  
    
GRANT SELECT ON TABLE geoscrub_input_view TO bien_read;


  		












  

    
      trunk/schemas/vegbien.sql
    
  





  2844
  2844
  
    
    LANGUAGE sql


  		




  2845
  2845
  
    
    AS $$


  		




  2846
  2846
  
    
DROP TABLE IF EXISTS geoscrub_input;


  		




  2847
  
  
    
CREATE TABLE geoscrub_input AS SELECT * FROM geoscrub_input_view;


  		




  
  2847
  
    
CREATE TABLE geoscrub_input AS SELECT * FROM geoscrub_input_view LIMIT 0;


  		




  2848
  2848
  
    

  		




  2849
  2849
  
    
GRANT SELECT ON TABLE geoscrub_input TO bien_read;


  		




  2850
  2850
  
    
GRANT SELECT ON TABLE geoscrub_input_view TO bien_read;


  		












Also available in:  Unified diff