Project

General

Profile

« Previous | Next » 

Revision 10332

inputs/REMIB/Specimen/postprocess.sql: removed duplicate CREATE INDEX for the acronym column

View differences:

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