I know you already understand this, but I feel compelled to answer anyway, because some might not: if you are using a text field to specify your login credentials (user_id AKA user_name in the new schema) you'll have to join by the submitted value. All the tables within the identity schema use the serial/integer ID to perform joins.

Frankly, I don't actually care what fields go in the User table, because I don't use the default TG version in any of my projects. If the feeling is that the tables have too much information, please feel free to either change them or submit a ticket/patch with changes.

On 22 Apr, 2006, at 2:28 am, jvanasco wrote:

why are we doing joins on the user submitted user_id ?  why aren't

we joining on the 'id'  serial that SQLobject automagically creates for

us?


--
Jeff Watkins

'I know about people who talk about suffering for the common good. It's never bloody them! When you hear a man shouting "Forward, brave comrades!" you'll see he's the one behind the bloody big rock and the one wearing the only really arrow-proof helmet!'
-- Rincewind gives a speech on politics. (Terry Pratchett, Interesting Times)



--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to