> In PostgreSQL if you use quotes you have to use > the exact same case that was used to create the > table. If you don't, names will be converted to lower > case. In Oracle if you don't use quotes names will > be converted to upper case.
You could offer an "application DB" mode that quotes everything and an "integration DB" mode that quotes nothing (and lowercases for PG). Then only those with integrated DB's would have to "pay the price" of avoiding reserved words. <clickety-click> I just added that option to Dejavu's Postgres adapter, defaulting to "application DB" mode. Written, tested, and debugged in 15 minutes. Robert Brewer System Architect Amor Ministries [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 -~----------~----~----~----~------~----~------~--~---
