I want to use the OVERLAPS keyword in postgres, but it complains because the current DateTimeConverter doesn't explicity set the type.
This patch makes the change. This is my patch: It also corrects a tiny spelling error. Index: sqlobject/converters.py =================================================================== --- sqlobject/converters.py (revision 3536) +++ sqlobject/converters.py (working copy) @@ -163,7 +163,7 @@ registerConverter(time.struct_time, StructTimeConverter) def DateTimeConverter(value, db): - return "'%04d-%02d-%02d %02d:%02d:%02d'" % ( + return "TIMESTAMP '%04d-%02d-%02d %02d:%02d:%02d'" % ( value.year, value.month, value.day, value.hour, value.minute, value.second) Index: sqlobject/manager/command.py =================================================================== --- sqlobject/manager/command.py (revision 3536) +++ sqlobject/manager/command.py (working copy) @@ -874,7 +874,7 @@ help = ('Record state of table definitions. The state of each ' 'table is written out to a separate file in a directory, ' 'and that directory forms a "version". A table is also ' - 'added to your datebase (%s) that reflects the version the ' + 'added to your database (%s) that reflects the version the ' 'database is currently at. Use the upgrade command to ' 'sync databases with code.' % SQLObjectVersionTable.sqlmeta.table) ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss