"Richard (koorb)" <[EMAIL PROTECTED]> writes: > Afternoon everyone, > > I am trying to use a postgresql database, but it seems that due to it's > awareness of dependancies tables need to be created in a specific > order. on tg-admin sql create I am simply getting the error > >> psycopg2.ProgrammingError: Relation "tg_user" does not exist > > Because I am joining the tg_user from one of my own tables. After some > searching I understand it is possible to get SQLObject to specify the > order with something like soClasses or _so_classes but that's the limit > of my knowledge so far. > > Has anyone else had this problem or know how to specify the order?
Are you using separate model files? If it was just one file, the order should be built correctly for you... Anyway, you have to specify _so_classes as a list (I'm saying from the docs, I've chosen to avoid this by using just one model file) so I believe it would be something like: _so_classes = ['class1', 'TG_User', 'class2', ...] (I do a join on a table of mine that is tied to TG_User on a 1:1 basis. This table has more fields and is declared inside my model.py, so I didn't find that problem.) -- Jorge Godoy <[EMAIL PROTECTED]> --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/turbogears -~----------~----~----~----~------~----~------~--~---
