Re: [sqlalchemy] Re: onupdate not working with postgresql

2011-07-02 Thread Kartik Lakhotia
It was exactly da same problem i was facing.. Thaks a lot moodi. I got dis now -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to

[sqlalchemy] ondelete Cascade function not working in sqlalchemy

2011-07-01 Thread Kartik Lakhotia
Hi, I have described my tables declaratively with foreign key being used at many places. I did set onupdate and ondelete as Cascade but it is not working properly. It does not delete the values in the foreign key column when i delete that entry in primary key column. Even the restrict is also not

[sqlalchemy] Basic doubt regarding Foreign Key referenced columns

2011-07-01 Thread Kartik Lakhotia
Hi all, I am new to sqlalchemy and i have a very basic doubt If i specify multiple columns as foreign key using the foreign key constraint, is it necessary that atleast one of the referenced columns must be unique. I tried by specifying the unique constraint on the referenced columns making the

[sqlalchemy] onupdate not working with postgresql

2011-07-01 Thread Kartik Lakhotia
I have specified a column in my table as -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For

[sqlalchemy] Re: onupdate not working with postgresql

2011-07-01 Thread 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. -- You

Re: [sqlalchemy] Basic doubt regarding Foreign Key referenced columns

2011-07-01 Thread Kartik Lakhotia
thanks a lot Michael -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit