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

Mon Apr 4 14:52:36 UTC 2016

1 more thing, when using CREATE VIEW I am able to see the preview when I'm
logged ind, but when NOT logged in, CKAN fails.

On Mon, Apr 4, 2016 at 4:41 PM, Michael Nielsen <mic.niel84 at gmail.com>
wrote:

> 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/ce8fd2ef/attachment-0003.html>