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-primary-key-sequence-when-it-falls-out-of-sync > > > 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) >>> >> >> >
