onupdate not working with postgresql

[Kartik Lakhotia]

I have specified a column in my table as

[Kartik Lakhotia]

Sorry, i left a half finished message by mistake.
I have described a column as :

updated = Column(DateTime, onupdate = datetime.datetime.now())

But it leaves the field value null when any row is updated. I have also
tried using func.current_Timestamp but that doesnt work either.

[Moodi]

I too faced a similar problem. Spent a lot of time just to figure out that -

*These update functions do not work when you try to update the table
directly from database. *And actually they should not, as postgres does not
provide such feature in its database

When I tried updating from sqlalchemy session - things worked for me.
SQLalchemy has already implemented the required triggers for auto updation.
May be its the same problem for you.


*
*

[Kartik Lakhotia]

It was exactly da same problem i was facing..
Thaks a lot moodi. I got dis now