Seems to be a postgresql specific issue. Fails in the DAL at when executing 'select lastval()'. SQlite and MySQL are fine. The command also fails at the pg command line level. This was changed back in December but uncertain if the issue existed prior to this https://groups.google.com/forum/?fromgroups#!searchin/web2py/select$20lastval(). Only came across it 3 hours before you when attempting bulk_insert from a select.as_list() dict to move between databases. Cant see a quick or easy work around, and the issue probably needs a PR.
On Thu, Jun 26, 2014 at 11:42 PM, at <[email protected]> wrote: > > So it's incorrect or impermissible to add records with custom ids? > > Thanks > > > > On Thursday, 26 June 2014 16:33:02 UTC+5, at wrote: > >> >> Yes you are right. Without id=1 it's working. >> But if I insert data using postgres/psql with id=1, it doesn't give any >> error as well. >> >> Regards, >> AT >> >> On Thursday, 26 June 2014 15:39:20 UTC+5, Simon Ashley wrote: >>> >>> Believe it will be failing with the id=1 etc. Interfering with the >>> primary key/ auto increment. Try it without. >>> >>> -- > 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 a topic in the > Google Groups "web2py-users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/web2py/z-docU0cUN4/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- Greg Sier Sier Associates AU +61 7 55736422 -- 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.
