Project

General

Profile

« Previous | Next » 

Revision 10245

Added by Aaron Marcuse-Kubitza about 11 years ago

bugfix: inputs/*/*/postprocess.sql: made all operations idempotent, so that postprocess.sql can be run repeatedly (e.g. by new-style import)

View differences:

postprocess.sql
1 
ALTER TABLE :table ALTER COLUMN latitude TYPE double precision
2 
USING latitude::double precision;
3 
ALTER TABLE :table ALTER COLUMN longitude TYPE double precision
4 
USING longitude::double precision;
5 
ALTER TABLE :table ALTER COLUMN error_km TYPE double precision
6 
USING error_km::double precision;
1 
SELECT util.search_path_append('util');
2 

  		




  
  3
  
    
SELECT set_col_types(:table_str, ARRAY[


  		




  
  4
  
    
  ('latitude', 'double precision')


  		




  
  5
  
    
, ('longitude', 'double precision')


  		




  
  6
  
    
, ('error_km', 'double precision')


  		




  
  7
  
    
]::col_cast[]);


  		












Also available in:  Unified diff