[sqlalchemy] Re: sqlalchemy.exceptions.SQLError: (ProgrammingError) can't adapt

2007-06-08 Thread A. Grossman
w after the default has been applied, you probably want > to specify it at least as: > > Column('workorderlines_rowid', PassiveDefault(""), Numeric(10,0)), > > where the PassiveDefault indicates to the ORM that a default fired > off on the DB side and should be

[sqlalchemy] Re: sqlalchemy.exceptions.SQLError: (ProgrammingError) can't adapt

2007-06-08 Thread A. Grossman
Hmmm. Perhaps I oversimplified my code for the example. The workorderlines_rowid isn't actually a primary key; given the following code where it is not one: from sqlalchemy import * db = create_engine('postgres://[EMAIL PROTECTED]:5432/fleettest') db.echo = True metadata = BoundMetaData(db)