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

[Michael Nielsen]

Hi Ian, as of now I'm editing directly in the DB, but it fails.
I'm kind of need this to work quickly. But the behaviour is very odd.
VIEWS does work, when my user is logged in the web and is viewable through
reclinejs, but when I'm logged OUT it does not work.

On Mon, Apr 4, 2016 at 5:01 PM, Ian Ward <ian at excess.org> wrote:

> 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
> >
> _______________________________________________
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20160404/ded9c3ad/attachment-0003.html>