Just noticed this had a followup. I did as you said and sure enough, some of the tables name had reserved words (dont ask me how they would work before but now they wouldnt). Anyways, that did the trick.
Thanks On Tuesday, March 6, 2018 at 9:33:39 PM UTC-8, Massimo Di Pierro wrote: > > never see that error. use postgres all the time. Can you try with a fresh > db and nothing in databases... adding one table at the time? My help narrow > it down. > > On Thursday, 1 March 2018 16:37:04 UTC-6, greenpoise wrote: >> >> Hello there. >> >> Been trying to revive an app I had and somewhere in between updates it >> broke which is not a big deal but here is the thing. I switched (on a new >> blank .py model), to postgresql from SQLITE and all I get is errors similar >> to this: >> >> self.errorProgrammingError(u'ERROR', u'42P07', u'relation ..., u'1066', >> u'heap_create_with_catalog', u'', u'') >> >> so..after a while I decided to go back to SQLite and the tables work and >> are created. Just wanted to throw this in here. >> >> >> thanks >> > -- 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.
