Add region deletion - Githubissues

opendatacube / datacube-dataset-config

Scripts for indexing data into ODC instances

22 stars 27 forks source link

Add region deletion #23

Closed pindge closed 4 years ago

pindge commented 4 years ago

add region deletion for new explorer introduced region table
delete product_ref from source_product_refs and derived_product_refs
tested and can confirm it is working.
update doc

pindge commented 4 years ago

UPDATE cubedash.product 
SET    derived_product_refs = Array_remove(derived_product_refs, ((SELECT id 
                                      FROM   agdc.dataset_type 
                                      WHERE  NAME = :'product_name') :: 
                              SMALLINT ));