Project

General

Profile

« Previous | Next » 

Revision 13140

Added by Aaron Marcuse-Kubitza over 10 years ago

fix: schemas/vegbien.sql: public_validations schema comment: to remove a validations query so its columns can be changed: use rm_output_queries() rather than rm_query_view() because that also removes input queries

View differences:

trunk/schemas/vegbien.sql
40 40 
**IMPORTANT**: run every `CREATE TYPE` with a comment containing "custom"
41 41 

  		




  42
  42
  
    
to remove a validations query so its columns can be changed:


  		




  43
  
  
    
SELECT public_validations.rm_query_view(''public_validations._view_name'');


  		




  
  43
  
    
SELECT public_validations.rm_output_queries(''public_validations._view_name'');


  		




  
  44
  
    
	-- not rm_query_view() because that also removes input queries


  		




  44
  45
  
    

  		




  45
  46
  
    
to change the key and value columns for a validations query:


  		




  46
  47
  
    
DROP   TYPE public_validations."keys_~type._view_name"    CASCADE;


  		












Also available in:  Unified diff