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

Mon Apr 4 15:01:34 UTC 2016

I think having postgres views as datastore resources would be great
and useful in a bunch of situations.  It's not supported by the
current datastore code (you've had to modify your datastore db
directly). Would you be interested in adding this as a datastore
feature with proper API calls and access checking?

Ian

On Mon, Apr 4, 2016 at 10:52 AM, Michael Nielsen <mic.niel84 at gmail.com> wrote:
> 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?
>>
>
>
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/ckan-dev
> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
>