Re: onupdate not working with postgresql

[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