Treat materialized views as a table-like

pudo / dataset

Easy-to-use data handling for SQL data stores with support for implicit table creation, bulk loading, and transactions.

https://dataset.readthedocs.org/

MIT License

4.76k stars 297 forks source link

Closed iantbutler01 closed 4 years ago

iantbutler01 commented 5 years ago

Expected behaviour:

db[""] returns a table object with the materialized view which you can query drop etc.

Actual behaviour:

DB: postgres9.6

db = dataset.connect("--------")
db["language_tagging_dataset_table"].drop()
tagged_posts = db["tagged_posts"] (this is the view)

reflect_views is left alone, using the default config.

It looks like regular views might be fine just not materialized views