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

Michael Nielsen mic.niel84 at gmail.com
Mon Apr 4 14:41:16 UTC 2016


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>


More information about the ckan-dev mailing list