The following code works on windows but crashes on linux. It uses SA 0.1.7. I am not sure whether the first import line makes problems, but as I said it works fine on windows. Both running Python-2.4.2
any help is appreciated Alex. ####### code ########### import mx.DateTime.DateTime as mxDateTime from sqlalchemy import * e = create_engine("postgres://database=test", echo=True) test = Table("test", e, Column("id", Integer, primary_key=True), Column("date", Date), Column("last_entry", Time), ) class Test(object): pass Test.mapper = mapper(Test, test) try: test.drop() except: pass test.create() t = Test() t.date = mxDateTime(2004,12,30) t.last_entry = mxDateTime(2004,12,31,23,55,56.345) objectstore.flush() ####### error message ######## [2006-05-21 10:14:06,398] [engine]: DROP TABLE test [2006-05-21 10:14:06,398] [engine]: None [2006-05-21 10:14:06,431] [engine]: CREATE TABLE test( id SERIAL NOT NULL PRIMARY KEY, date DATE, last_entry TIME ) [2006-05-21 10:14:06,431] [engine]: None [2006-05-21 10:14:06,505] [engine]: select nextval('test_id_seq') [2006-05-21 10:14:06,505] [engine]: None [2006-05-21 10:14:06,509] [engine]: INSERT INTO test (id, date, last_entry) VALUES (%(id)s, %(date)s, %(last_entry)s) [2006-05-21 10:14:06,509] [engine]: {'date': <DateTime object for '2004-12-30 00:00:00.00' at 40232598>, 'last_entry': <DateTime object for '2004-12-31 23:55:56.34' at 404c6250>, 'id': 1L} Traceback (most recent call last): File "test2.py", line 25, in ? objectstore.flush() File "build/bdist.linux-i686/egg/sqlalchemy/mapping/objectstore.py", line 260, in flush File "build/bdist.linux-i686/egg/sqlalchemy/mapping/objectstore.py", line 81, in flush File "build/bdist.linux-i686/egg/sqlalchemy/mapping/unitofwork.py", line 249, in flush File "build/bdist.linux-i686/egg/sqlalchemy/mapping/unitofwork.py", line 374, in execute File "build/bdist.linux-i686/egg/sqlalchemy/mapping/unitofwork.py", line 527, in execute File "build/bdist.linux-i686/egg/sqlalchemy/mapping/mapper.py", line 616, in save_obj File "build/bdist.linux-i686/egg/sqlalchemy/sql.py", line 473, in execute File "build/bdist.linux-i686/egg/sqlalchemy/sql.py", line 378, in execute File "build/bdist.linux-i686/egg/sqlalchemy/sql.py", line 355, in execute File "build/bdist.linux-i686/egg/sqlalchemy/engine.py", line 646, in execute_compiled File "build/bdist.linux-i686/egg/sqlalchemy/engine.py", line 641, in proxy File "build/bdist.linux-i686/egg/sqlalchemy/engine.py", line 692, in execute File "build/bdist.linux-i686/egg/sqlalchemy/engine.py", line 712, in _execute sqlalchemy.exceptions.SQLError: (ProgrammingError) can't adapt 'INSERT INTO test (id, date, last_entry) VALUES (%(id)s, %(date)s, %(last_entry)s)' {'date': <DateTime object for '2004-12-30 00:00:00.00' at 40232598>, 'last_entry': <DateTime object for '2004-12-31 23:55:56.34' at 404c6250>, 'id': 1L} ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid0709&bid&3057&dat1642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users