Hmm defaults work quite fine for me. I'm not sure what you mean with: "when i look into the database after tg-admin sql create, there is no default value there". Setting default in sqlobject doesn't create a row in the table. It provides a default value when creating a new SQLObject instance when you don't provide a specific value. eg:
class Person(SQLObject): name = StringCol() country = StringCol(default="Unkown") >> john = Person( name="John", country="Nomansland") >> jim = Person( name="Jim") >> print john.country Nomansland >> print jim.country Unkown The catwalk issue seems to be a bug for which i have made a ticket (538).
