Project

General

Profile

« Previous | Next » 

Revision 12367

Added by Aaron Marcuse-Kubitza over 10 years ago

fix: schemas/vegbien.sql: _traits_08_taxonname_trait_and_value_for_first_5000_records: renamed to _traits_08_taxonname_trait_and_value because this actually includes all the records, not just the first 5000. this uses the new public_validations.rename_query_view() to rename all associated tables and views, including handling truncated names.

View differences:

vegbien.sql
6196 6196 

  		




  6197
  6197
  
    

  		




  6198
  6198
  
    
--


  		




  6199
  
  
    
-- Name: _traits_08_taxonname_trait_and_value_for_first_5000_records; Type: VIEW; Schema: public_validations; Owner: -


  		




  
  6199
  
    
-- Name: _traits_08_taxonname_trait_and_value; Type: VIEW; Schema: public_validations; Owner: -


  		




  6200
  6200
  
    
--


  		




  6201
  6201
  
    

  		




  6202
  
  
    
CREATE VIEW _traits_08_taxonname_trait_and_value_for_first_5000_records AS


  		




  
  6202
  
    
CREATE VIEW _traits_08_taxonname_trait_and_value AS


  		




  6203
  6203
  
    
 SELECT concat_ws(' '::text, taxonverbatim.taxonname, taxonverbatim.author) AS taxonwithauthor, 


  		




  6204
  6204
  
    
    trait.name AS trait, 


  		




  6205
  6205
  
    
    trait.value


  		












Also available in:  Unified diff