Revision 10332
Added by Aaron Marcuse-Kubitza over 11 years ago
inputs/REMIB/Specimen/postprocess.sql | ||
---|---|---|
1 | 1 |
SELECT util.search_path_append('util'); |
2 | 2 |
|
3 |
SELECT create_if_not_exists($$CREATE INDEX "Specimen.acronym" ON $$||:table_str||$$ (acronym)$$); |
|
4 |
|
|
5 | 3 |
SELECT create_if_not_exists($$CREATE INDEX "Specimen.acronym" ON $$||:table_str||$$ (acronym)$$); |
6 | 4 |
SELECT create_if_not_exists($$CREATE INDEX "Specimen.coll_year" ON $$||:table_str||$$ (coll_year)$$); |
7 | 5 |
SELECT create_if_not_exists($$CREATE INDEX "Specimen.country" ON $$||:table_str||$$ (country)$$); |
Also available in: Unified diff
inputs/REMIB/Specimen/postprocess.sql: removed duplicate CREATE INDEX for the acronym column