I used 1.99.4 for two projects using apache, mod_wsgi, postgresql 8.4, psycopg2 on RHEL 6.
But I never use Rocket or pg8000 driver and I didn't use temporary tables with these... Did use auth quite a bit, though. Anyway, this just goes towards how many different combinations need to be tested. Richard, Johann, any chance of doing basic sample apps that reliably recreate these migration issues...? That, combined with a bug ticket, would be the best approach to let more people look into this quickly. I think postgresql is quite popular in web2py world. Regards, Ales On Thursday, November 15, 2012 7:49:47 AM UTC+1, Johann Spies wrote: > > I am using the trunk code updated daily on my development computer and > recently have had to kill web2py processes manually because of migration > issues. I am also using postgresql and this happened regularly while > experimenting with temporary tables. > > Example: I use 'create table x as select ... from ...' for some queries > in postgresql to create temporary tables. > > When an error occurs in communicating with postgesql usually related to > some migration issue, I have to kill the web2py process on operating system > level using the -9 switch because of no response from web2py. Ctrl-C will > do nothing and a normal kill also has no effect. > > Now I use migrate=False with fake-migrate to manage those tables. > > Regards > Johann > --

