Revision 11008
Added by Aaron Marcuse-Kubitza about 11 years ago
| inputs/VegBank/stemlocation_/postprocess.sql | ||
|---|---|---|
| 8 | 8 |
SELECT mk_derived_col((:table_str, 'aggregateOrganismObservationID'), |
| 9 | 9 |
$$_join("aggregateOrganismObservationID__taxon_presence"::text, "aggregateOrganismObservationID__individual_count"::text)$$)
|
| 10 | 10 |
; -- runtime: 0.5 s ("Time: 441.059 ms") @starscream
|
| 11 |
|
|
| 12 |
|
|
| 13 |
SELECT create_if_not_exists($$CREATE INDEX $$||:table_str||%'__parent'||$$ ON $$||:table_str||$$ ("aggregateOrganismObservationID")$$); -- runtime: 0.1 s ("Time: 131.907 ms") @starscream
|
|
Also available in: Unified diff
bugfix: inputs/VegBank/stemlocation_/postprocess.sql: added missing index on aggregateOrganismObservationID, needed for the 1:many portion of the taxon_observation.** left-join