INSERT or UPDATE? I don't do any inserts with this code... only changing what's already there.
Is an integrity constraint a PG thing, or SQLAlchemy model thing? And can I do Session.rollback() ? Thanks! On Jun 27, 2:19 pm, Michael Bayer <[EMAIL PROTECTED]> wrote: > On Jun 27, 2008, at 4:03 PM, Matt Haggard wrote: > > > > > I'm getting a ProgrammingError (I've pasted the last part of the > > traceback at the bottom of the page). > > > The error comes from my first heavy-AJAX page in Pylons (postgres > > backend). If I cause too many AJAX requests at a time, or even after > > doing 3 non-overlapping AJAX requests, I get the error. I wonder if > > there's some sort of handle releasing I need to do... or transaction > > releasing? > > > As a side note... I test using SQLite and put in production with > > Postgres, and the page works wonderfully in SQLite -- it's only > > Postgres that has the problem. > > PG has this issue if you attempt to INSERT a row which throws an > integrity constraint; a rollback() is required after this occurs. I > can't see it in your code below but it would imply that such an > exception is being caught and then thrown away. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---