the scheduler though doesn't know anything about the search path when it rebuilds its own model... that's why setting search_path is undocumented ^_^
you can try fiddling with the source of the scheduler (along these lines https://github.com/web2py/web2py/blob/master/gluon/scheduler.py#L948) to set the same search path. Please be aware that even if it seems to work, support for it is not assured (so use at your own risk) On Friday, June 3, 2016 at 7:19:02 PM UTC+2, Bart wrote: > > Hi Niphlod, > > Normally i just put a record in the scheduler_task table with appadmin. > That works fine (no errors), but nothing happens because the scheduler > worker is not running. > > In db.py the database schema is set via db.executesql("set search_path to > auth,scheduler, ... ;") > > In case migrate is True, the search_path is set to scheduler, auth, ... > just before the scheduler = Scheduler(db) statement. > > > > Op vrijdag 3 juni 2016 18:35:07 UTC+2 schreef Niphlod: >> >> what happens when you try to queue a task from the app ? AFAIK I'd be >> eager to know how can it work if there is no "public" schema, unless you >> tinkered with scheduler's table definitions >> >> On Friday, June 3, 2016 at 4:57:23 PM UTC+2, Bart wrote: >>> >>> Addition: >>> >>> I am using several schema's in the postgres database. >>> >>> The scheduler tables are in schema 'scheduler' >>> >>> Schema 'public' does not exist. >>> >>> Can this cause the problem? >>> >> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
