SELECT util.search_path_append('util');

SELECT force_update_view('"occurrence_all"', $$
SELECT "*TREE-row_num" AS "occurrence_all-row_num", *
/* directional joins ensure that the PostgreSQL query planner always joins
starting with the TREE table */
FROM              "TREE"
NATURAL LEFT JOIN "REF_SPECIES"
NATURAL LEFT JOIN "REF_PLANT_DICTIONARY"
NATURAL LEFT JOIN "SUBPLOT"
NATURAL LEFT JOIN "COND"
NATURAL LEFT JOIN "REF_HABTYP_DESCRIPTION"
NATURAL LEFT JOIN "PLOT"
NATURAL LEFT JOIN "COUNTY"
NATURAL LEFT JOIN "REF_UNIT"
NATURAL LEFT JOIN "REF_RESEARCH_STATION"
$$);

SELECT mk_subset_by_row_num_func('"occurrence_all"', 'occurrence_all-row_num');