lter / LTER-core-metabase

RDB model, based on the GCE LTER Metabase, with adaptations from other LTER sites
https://lter.github.io/LTER-core-metabase/
GNU General Public License v3.0
9 stars 4 forks source link

pkg_state, pkg_sort contain entire inventory of SBC instead of just 4 example rows #80

Closed gastil closed 4 years ago

gastil commented 4 years ago

A simple fix, but needs to be done on the dev installation from which OneBigFile is made. We accidentally included the entire inventory of 265 rows of pkg_state and 254 rows of pkg_sort from Margaret's copy of pkg_mgmt rather than just the 4 example datasets.

delete from pkg_mgmt.pkg_core_area
where "DataSetID" < 99000 or "DataSetID" > 100000
;
delete from pkg_mgmt.pkg_core_area
where "DataSetID" < 99000 or "DataSetID" > 100000
;
delete from pkg_mgmt.pkg_sort
where "DataSetID" < 99000 or "DataSetID" > 100000
;

Just run that one time on the dev installation. Do not make a patch.

atn38 commented 4 years ago

on it. this will be lumped in with the 35 patch note the edit below

delete from pkg_mgmt.pkg_core_area
where "DataSetID" < 99000 or "DataSetID" > 100000
;
delete from pkg_mgmt.pkg_state
where "DataSetID" < 99000 or "DataSetID" > 100000
;
delete from pkg_mgmt.pkg_sort
where "DataSetID" < 99000 or "DataSetID" > 100000
;