Here is a dependency I did not catch, or that table was created after this delete script was written. Heads up we'll have to update delete scripts as we add tables.
psql -U gastil -h rdb2 sbc_lter_core_mb < 26_delete_example_datasets.sql
Password for user gastil:
...
table "DataSet" violates foreign key constraint "FK_maintenance_changehistory_DataSetID" on table "maintenance_changehistory"
DETAIL: Key (DataSetID)=(99021) is still referenced from table "maintenance_changehistory".
INSERT 0 1
Here is a dependency I did not catch, or that table was created after this delete script was written. Heads up we'll have to update delete scripts as we add tables.