[sqlalchemy] DataError: invalid input value for enum

I have a model that looks something like this: TRANS_CODES = ( 'SellCar', 'BuyCar', 'BuyFee', 'SellFee', 'Gas/Fuel', 'Detail', 'Wash/Vac', 'Trans/Hauling', 'Service/Repair', 'DraftFee', 'Misc', 'Cash', 'CheckPaid', 'CheckRcvd', 'FloorPlan', 'Draft') class Trans(Base): __tablename__

Re: [sqlalchemy] DataError: invalid input value for enum

check that the ENUM type which was generated, or its CHECK constraint, includes Cash. With the Enum type, you can't add new values to the list without also changing the ENUM type or CHECK constraint. On Oct 31, 2010, at 7:25 PM, Michael Hipp wrote: I have a model that looks something