I have a perplexing problem and I'm really hopping that there is a setting or something stupid that I've missed. Here is the issue, I have an application most of my page data is coming from a postgres database. I've designed an admin interface which allows you to edit the database, however, when I leave the admin interface and look at the page as a normal user, I see old data, not the new data. If I look at the database directly with pgadmin the new data has been entered. I am using postgres, python 2.4 pylons 0.9.6 rc2. Here is some example code:
ini file: sqlalchemy.default.url = postgres://user:[EMAIL PROTECTED]/epathology model: from sqlalchemy import * from sqlalchemy.orm import * form sqlalchemy.ext.assignmapper import assign_mapper from sacontext import PylonsSAContext sac = PylonsSAContext() sac.add_engine_from_config('default') ctx = sac.session_context table1 = Table('table1', sac.metadata, autoload=True) class Table1(object): pass assign_mapper(ctx, Table1, table1, extension=sac.ext) to set data I do: rec = model.Table1.get(id) rec.someattribute = "new value" rec.save() # I has not been doing this initially, I just added this to see if it would help, it did not model.sac.session.flush() to get data I do: data = model.rec.select() This seems to work, however like I said when I edit the data more often then not the application reflects old data, like its getting data from a cache or using an old session to retrieve data from. What am I doing wrong? this is really frustrating. Well thanks for any and all help Jose --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To post to this group, send email to pylons-discuss@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/pylons-discuss?hl=en -~----------~----~----~----~------~----~------~--~---