ddlog icon indicating copy to clipboard operation
ddlog copied to clipboard

If table defined first as view, then table, view isn't dropped

Open Colossus opened this issue 9 years ago • 1 comments

In ddlog, if you don't specify a table layout, arbitrary queries are being set up as views. If you later decide to "materialize" the view by writing a table definition in DDLog and recompiling, you get an error:

2016-02-16 11:47:16.529170 ERROR: "genepheno_factor" is not a base table 2016-02-16 11:47:16.529280 HINT: Use DROP VIEW to remove a view.

workaround: drop view manually, then proceed

Colossus avatar Feb 16 '16 19:02 Colossus

Thanks for reporting. We'll clean this up pretty soon. @ThomasPalomares and I were discussing the idea of using a rule annotation such as @materialize to decide whether a head becomes a table or view, and keep everything by default as views. (Function call output must be materialized anyway though.)

netj avatar Feb 16 '16 19:02 netj