Remove or rename errored tables under nldi_data schema

internetofwater / nldi-db

Network Linked Data Index Database Component

https://waterdata.usgs.gov/blog/nldi-intro/

Creative Commons Zero v1.0 Universal

3 stars 15 forks source link

Remove or rename errored tables under nldi_data schema #36

Closed coobr01 closed 2 years ago

coobr01 commented 7 years ago

Seems to be in both database instances.

Looks like it came from https://github.com/ACWI-SSWD/nldi-db/blob/master/nldi-liquibase/src/main/resources/liquibase/nldi_data/tables.sql

dblodgett-usgs commented 2 years ago

@EthanGrahn -- is this still an issue?

EthanGrahn commented 2 years ago

@dblodgett-usgs If this is referring to tables with _temp, then yes. They are supposed to be automatically created by the crawler and cleaned up after ingestion is complete. The feature; select * from pg_class; is intended to prevent a specific SQL injection, so that's supposed to be there.

dblodgett-usgs commented 2 years ago

OK -- We'll leave this open. It would make sense to have those temp tables get dropped if not needed anymore.