[sqlalchemy] Integer Array Unique Key

2008-04-05 Thread Madhu Alagu
Hi, 1. controller_action_id integer[] 2. UNIQUE(order_id, product_id) How can I create a table. Thanks Madhu Alagu --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group,

[sqlalchemy] Re: Does SQLAlchemy ORM use column indexes to optimize queries?

2008-04-05 Thread GK
Michael, Thank you for your response - it was very helpful for me. It turns out my main problem was that I was importing an order of magnitude or so more data than I realized, but you were also right about using flush(). You were also right about the overhead of creating extra indexes. In the

[sqlalchemy] Re: Does SQLAlchemy ORM use column indexes to optimize queries?

2008-04-05 Thread jason kirtland
GK wrote: Michael, Thank you for your response - it was very helpful for me. It turns out my main problem was that I was importing an order of magnitude or so more data than I realized, but you were also right about using flush(). You were also right about the overhead of creating

[sqlalchemy] Re: why something not show the updated items ?

2008-04-05 Thread 张沈鹏(电子科大 毕/就业倒计时...)
thanks for you answer :) but I still have some problems It's to say I should clear session manual once I update the database ? can I set timeout somewhere to auto do this job ? On Sat, Apr 5, 2008 at 11:58 PM, Michael Bayer [EMAIL PROTECTED] wrote: On Apr 5, 2008, at 12:19 AM, 张沈鹏(电子科大

[sqlalchemy] Re: why something not show the updated items ?

2008-04-05 Thread Michael Bayer
On Apr 5, 2008, at 1:13 PM, 张沈鹏(电子科大 毕/就业倒计 时...) wrote: thanks for you answer :) but I still have some problems It's to say I should clear session manual once I update the database ? can I set timeout somewhere to auto do this job ? for a web application, you usually use a Session