Users in our system are assigned several varchar "groupcodes". My problem is that these groupcodes are defined in an old legacy table called "customers" that's quite un-normalized, so that a groupcode might be listed in that table many times. Obviously this isn't a great arrangement, but fixing the root problem isn't possible at this time.
So, I basically need to convince TG and SQLAlchemy that "customers.groupcode" is unique so I can display those values in popups and create a many-to-many table linking users_table to customers. I tried creating a view, but PostgreSQL wasn't keen on allowing foreign keys to views. I've looked at this so long that my mind is getting fuzzy. -- Kirk Strauser --~--~---------~--~----~------------~-------~--~----~ 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?hl=en -~----------~----~----~----~------~----~------~--~---
