what is the error? you may to first truncate all the tables referencing that table, in particular the _archive tables.
On Monday, 2 January 2017 00:00:06 UTC-6, 黄祥 wrote: > > is it possible to truncate tables with record versioning enabled? > *e.g.* > def truncate(): > for table in db.tables: > if '_archive' in table: > db[table].truncate() > > # define tables which don't have record versioning, when record versioning > enables it return an error traceback about reference to _archive table > #db.auth_user.truncate() # tried several times always return an error above > > # work > db.scheduler_run.truncate() > db.scheduler_worker.truncate() > db.auth_event.truncate() > #db.scheduler_task.truncate() # this one is special case, it refers to > scheduler_run table > > any idea how to face it using web2py way? > > thanks and best regards, > stifan > -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
