Revision 11753
Added by Aaron Marcuse-Kubitza about 11 years ago
| inputs/CVS/plantConcept_/postprocess.sql | ||
|---|---|---|
| 1 | 1 |
SELECT util.search_path_append('util');
|
| 2 | 2 |
|
| 3 |
SELECT create_if_not_exists($$ALTER TABLE $$||:table_str||$$ ADD PRIMARY KEY ("*PLANTCONCEPT_ID")$$); -- runtime: ~0 @starscream
|
|
| 3 |
SELECT create_if_not_exists($$ALTER TABLE $$||:table_str||$$ ADD PRIMARY KEY ("PLANTCONCEPT_ID")$$); -- runtime: ~0 @starscream
|
|
| 4 | 4 |
|
| 5 | 5 |
|
| 6 | 6 |
SELECT mk_derived_col((:table_str, 'division'), |
Also available in: Unified diff
bugfix: inputs/CVS/plantConcept_/map.csv: PLANTCONCEPT_ID: remapped without * prefix so that the USING join in inputs/CVS/taxonObservation_/create.sql would continue to work