[sqlalchemy] Re: Bit of A Memory Problem with Python/SA

2007-06-14 Thread i20
Which version of python have you used? It appears that on our server we encountered the same problem of memory leak when we used python 2.4.1 (on debian sarge) (with several version of SA). With python 2.4.4 and 2.5.1, we don't have large memory consumption anymore. If our experience can help

[sqlalchemy] Failed updates on partitioned tables PostgreSQL

2007-06-14 Thread Daniele Varrazzo
Hello, partitioned tables in PostgreSQL don't report the correct number of updated rows, so updates from a mapper fail. Reported by Antonio on the postgresql-it mailing list. I was able to reproduce the bug this way: -- Database CREATE TABLE xtable ( id serial primary key,

[sqlalchemy] engine.base._convert_key() fails with long col names

2007-06-14 Thread Andreas Jung
From: Andreas Jung [EMAIL PROTECTED] To: sqlalchemy@googlegroups.com Subject: engine.base._convert_key() fails with long col names Date-Sent: 14. Juni 2007 15:14:37 Hi, I am getting the following traceback * Module toolbox.product.export_bauplan2, line 96, in export_bauplan * Module

[sqlalchemy] Autoloading tables on old versions of MySQL

2007-06-14 Thread King Simon-NFHD78
Hi, I just noticed that autoloading of tables on old versions of MySQL is broken (I'm using 3.23.58, but I believe the problem will occur up to 4.1.1) The problem is that reflecttable tries to use the 'character_set_results' system variable, which was only introduced in 4.1.1. The attached patch

[sqlalchemy] Re: Failed updates on partitioned tables PostgreSQL

2007-06-14 Thread Michael Bayer
On Jun 14, 2007, at 6:21 AM, Daniele Varrazzo wrote: Hello, partitioned tables in PostgreSQL don't report the correct number of updated rows, so updates from a mapper fail. Reported by Antonio on the postgresql-it mailing list. An obvious fix is reported below, i don't know if there is

[sqlalchemy] Re: engine.base._convert_key() fails with long col names

2007-06-14 Thread Michael Bayer
On Jun 14, 2007, at 9:16 AM, Andreas Jung wrote: This happens when _convert_key() is called with key='arbeitsmittelhierarchy_arbeitsmittel_view.stammdatenverwaltung_ta uglich' im confused. are you passing that string directly to row[some key] ? result column names cant have periods

[sqlalchemy] Re: Autoloading tables on old versions of MySQL

2007-06-14 Thread Michael Bayer
put up a ticket for this, else we'll forget to get around to it... On Jun 14, 2007, at 11:08 AM, King Simon-NFHD78 wrote: Hi, I just noticed that autoloading of tables on old versions of MySQL is broken (I'm using 3.23.58, but I believe the problem will occur up to 4.1.1) The problem is

[sqlalchemy] Re: engine.base._convert_key() fails with long col names

2007-06-14 Thread Andreas Jung
--On 14. Juni 2007 14:13:47 -0400 Michael Bayer [EMAIL PROTECTED] wrote: On Jun 14, 2007, at 9:16 AM, Andreas Jung wrote: This happens when _convert_key() is called with key='arbeitsmittelhierarchy_arbeitsmittel_view.stammdatenverwaltung_ta uglich' im confused. are you passing that