If it helps, any parameters you pass to truncate() get passed on to the database driver. What happens after that I do not know, except for Postgres.
I researched the issue because I didn't want to drop and regen my tables every time I run an acceptance test. On Dec 8, 5:04 pm, Richard Vézina <[email protected]> wrote: > Also, if you use to create your table in postgres manually (not wrinting > models first in web2py and let web2py create you table for you) it maybe > possible that you have to define your sequence name since web2py don't > follow postgres standard name for sequence creation... So maybe your > sequence name are not defined and not the same as web2py meta data are... > So web2py send wrong order to postgres backend?! > > Richard > > On Thu, Dec 8, 2011 at 5:00 PM, Richard Vézina > <[email protected]>wrote: > > > > > > > > > Here a post on stack overflow that could help : > >http://stackoverflow.com/questions/244243/how-to-reset-postgres-prima... > > > On Thu, Dec 8, 2011 at 4:55 PM, Richard Vézina < > > [email protected]> wrote: > > >> I think you will need to use raw sql for this... > > >>http://web2py.com/book/default/chapter/06?search=raw+sql#Raw-SQL > > >> At least it one way I see that it could work... > > >> But I remember that I have read something about resetting sequence from > >> web2py... > > >> Richard > > >> On Thu, Dec 8, 2011 at 4:14 PM, Alan Etkin <[email protected]> wrote: > > >>> Does it work for sqlite3 or MySQL, etc? > > >>> On Dec 8, 5:27 pm, nick name <[email protected]> wrote: > >>> > Interesting. DAL has specific reset code for MS SQL and SQLite, but > >>> not for > >>> > postgresql (or any of the other databases, it seems)
