[sqlalchemy] problems with pickle and RowProxy

2009-10-11 Thread Manlio Perillo
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi. I have noted a problem when a I try to pickle an instance of sqlalchemy.engine.base.RowProxy: ... File /usr/lib/python2.5/pickle.py, line 306, in save rv = reduce(self.proto) File /usr/lib/python2.5/copy_reg.py, line 76, in _reduce_ex

[sqlalchemy] Re: problems with pickle and RowProxy

2009-10-11 Thread Michael Bayer
On Oct 11, 2009, at 8:06 AM, Manlio Perillo wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi. I have noted a problem when a I try to pickle an instance of sqlalchemy.engine.base.RowProxy: ... File /usr/lib/python2.5/pickle.py, line 306, in save rv = reduce(self.proto)

[sqlalchemy] Re: Updating a table with a trigger silently fails (SQL Server)

2009-10-11 Thread Michael Bayer
On Oct 11, 2009, at 9:32 AM, Nicol van der Merwe wrote: Hi All I am using sqlsoup and pyodbc to update a couple of rows in the database. On a number of tables in the database I have triggers that basically checks keeps a log of changes on certain columns in the table (inserts

[sqlalchemy] Re: problems with pickle and RowProxy

2009-10-11 Thread Manlio Perillo
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Michael Bayer ha scritto: On Oct 11, 2009, at 8:06 AM, Manlio Perillo wrote: Hi. I have noted a problem when a I try to pickle an instance of sqlalchemy.engine.base.RowProxy: ... File /usr/lib/python2.5/pickle.py, line 306, in save

[sqlalchemy] Re: problems with pickle and RowProxy

2009-10-11 Thread Michael Bayer
On Oct 11, 2009, at 11:13 AM, Manlio Perillo wrote: My use case is quite simple; I always call .fetchall from a ResulProxy, so all data is in memory. I don't see any reasons why a RowProxy should not be pickleable in this case. I have tried with SQLAlchemy 0.4.2p3 (the version I'm

[sqlalchemy] Re: Very odd utf8 problem

2009-10-11 Thread Yo'av Moshe
No, the error is an UnicodeDecodeError (http://paste2.org/p/457059). I can't just try a different DB, switch to SQLite, etc. As I've said, my website is on production and I have a lot of users using it. Also, the problem is something that started lately, probably because of some content that a

[sqlalchemy] Re: Very odd utf8 problem

2009-10-11 Thread Michael Bayer
On Oct 11, 2009, at 2:29 PM, Yo'av Moshe wrote: No, the error is an UnicodeDecodeError (http://paste2.org/p/457059). I can't just try a different DB, switch to SQLite, etc. As I've said, my website is on production and I have a lot of users using it. the purpose of trying a different