I have an Oracle schema that has a column name labeled as 'when' (without the quotes). Everything works fine in PL/SQL when referencing this column -- not special handling needs to be done. However, we created a sqlalchemy definition as follows:
monitor_mts_table = Table('monitor_mts', metadata, Column('monitor_mts_id', Integer, Sequence('seq_monitor_mts'), primary_key = True), Column('when', OracleDateTime), Column('status', Integer), Column('created_date', OracleDateTime), ) When we reference this we get a database error from oracle that the column monitor_mts."when" does not exist. Notice the double quotes. This is what is throwing off oracle since the column definition in the table is not double quoted. I have tried appending the clause quote=False to the Column definition above but it does not affect what is being sent to the database -- still a doubled quoted column name. Any ideas how to work around this without changing the underlying table definition in Oracle? Thanks, Dan --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---