[sqlalchemy] postgres and server_side_cursors

2007-01-23 Thread Michele Petrazzo
Hi, I'm trying the new server_side_cursors option with pg and I see that I receive an error when I use the server_side_cursors=True and the Table autoload=True. The autoload=True with the server_side_cursors=False work. The server_side_cursors=True specifying the table structure work. (I'm

[sqlalchemy] Re: postgres and server_side_cursors

2007-01-23 Thread Michele Petrazzo
Michael Bayer wrote: ive heard of this one already, which is why the option is turned off. unfortunately I cant reproduce that here, so until someone wants to figure out whats going on with that, not sure what I can do. Tell me what I have to do. Here I have debian etch and pg 8.1.(the last

[sqlalchemy] Re: postgres and server_side_cursors

2007-01-23 Thread Michele Petrazzo
Michael Bayer wrote: ive heard of this one already, which is why the option is turned off. unfortunately I cant reproduce that here, so until someone wants to figure out whats going on with that, not sure what I can do. After some tries, I see that is I wrote (very bad code line):

[sqlalchemy] Re: [Sqlalchemy-users] named cursor

2007-01-09 Thread Michele Petrazzo
Michael Bayer wrote: On Jan 9, 2007, at 5:24 AM, Michele Petrazzo wrote: Because, like what I wrote on the psycopg2 ml (lists.initd.org/ pipermail/psycopg/2007-January/005250.html) without the server side cursor, the memory usage on the client side is proportionally at the number