[ckan-dev] DataStore, DROP TABLE and recreate work, but DROP TABLE and recreate as VIEW fails.

[Michael Nielsen]

I would like to have some DataStore resources as VIEWs instead of TABLEs.

When I've created an empty DataStore resource, and deletes it with:

    DROP TABLE "resource_id"

everything works if I recreate the table with:

    CREATE TABLE AS (SELECT * FROM view);

but fails with:

    CREATE VIEW AS (SELECT * FROM view);

I would love CKAN to use the view, so everything is updated 100 %.

Shouldn't this be possible?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20160404/90ff4931/attachment-0002.html>