Project

General

Profile

« Previous | Next » 

Revision 10245

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 ADD PRIMARY KEY (specimen_id);
1
SELECT util.search_path_append('util');
2

  
3
SELECT create_if_not_exists($$ALTER TABLE $$||:table_str||$$ ADD PRIMARY KEY (specimen_id)$$);

Also available in: Unified diff