very strange. Are you using psycopg2 or pg8000? I do not trust the latter. On Tuesday, 24 November 2015 12:42:44 UTC-6, Mark Graves wrote: > > I'm using postgres, migrating from latin-1 mysql. > > Its a referenced table, and yes I definitely am calling db.commit() > > I will post the entire code tonight. > > Also, I have ~11k legacy documents to upload to S3 which I wanted to make > available via a uniform method. > > I was previously attempting to insert them via web2py, but I have > encountered segmentation faults in postgres using this method, so I may > just s3sync them and create a download link which I store in the database > to make my life easier. > > Anyone have any experience with that? > > On Mon, Nov 23, 2015 at 6:06 AM, Anthony <abasta...@gmail.com> wrote: > >> What does the code look like? Are you calling db.commit() at any point? >> >> >> On Sunday, November 22, 2015 at 9:58:05 PM UTC-5, Mark Graves wrote: >>> >>> Are there any caveats to know about running applications in shell mode >>> (e.g. transactions / returning id)? >>> >>> I'm running a middleware migration script to migrate someone off an old >>> database to a new one. >>> >>> When I run a db.table.validate_and_insert() it keeps returning me id 1. >>> This is yielding a duplicate key error understandably. >>> >>> It's like pydal and postgres are coming out of sync. >>> >>> Theres only one connection to the database, but the sequence is not >>> being updated. >>> >>> Any thoughts? >>> >>> >>> -- >> 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/P3I8e-Elq9I/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> web2py+unsubscr...@googlegroups.com. >> For more options, visit https://groups.google.com/d/optout. >> > >
-- 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.
