[sqlalchemy] Queue pool overflow error.

2011-05-16 Thread abhishek
Dear group, I am getting Queue pool overflow error very frequently in one of the websites in production. The production server is running two cherrypy sites (one for mobile access and another for PC access) targeting same database. My query here is should the value of SQLAlchemy pool size for

[sqlalchemy] select table from other schema

2011-05-16 Thread Ivan
I have table from schema test class AttributeConversion(Base): __tablename__ = 'test.attribute_conversion' How to select records from this table ? sqlalchemy make sql: :select * from test.attribute_conversion but it's work. right question must be :select * from test.attribute_conversion (

[sqlalchemy] InvalidRequestError: Unknown PG numeric type: 1043

2011-05-16 Thread Craig Swank
Hello, I am declaratively defining a table and am having trouble with adding a float column. I get this error: InvalidRequestError: Unknown PG numeric type: 1043 when I add a column with either: from sqlalchemy.dialects.postgresql import NUMERIC or from sqlalchemy import Float and the

Re: [sqlalchemy] InvalidRequestError: Unknown PG numeric type: 1043

2011-05-16 Thread Michael Bayer
On May 16, 2011, at 9:23 AM, Craig Swank wrote: Hello, I am declaratively defining a table and am having trouble with adding a float column. I get this error: InvalidRequestError: Unknown PG numeric type: 1043 when I add a column with either: from sqlalchemy.dialects.postgresql

[sqlalchemy] Re: InvalidRequestError: Unknown PG numeric type: 1043

2011-05-16 Thread Craig Swank
Indeed! That's what I get for defining my tables based on the pdf my manager gave me, instead of looking at the tables in psql directly. Thanks, I was stuck looking at my code for the problem. Craig On May 16, 7:53 am, Michael Bayer mike...@zzzcomputing.com wrote: On May 16, 2011, at 9:23 AM,

Re: [sqlalchemy] Get instances of certain type in a relationship that can contain objects of several types

2011-05-16 Thread Michael Bayer
On May 14, 2011, at 10:12 PM, Hector Blanco wrote: What I'd like is something like: class Whatever(declarativeBase): [ . . . ] def getAllowedUserGroups(self): session = Database.Session() query =

Re: [sqlalchemy] AttributeError: 'Preprocess' object has no attribute 'detach' during Session.close

2011-05-16 Thread Torsten Landschoff
On Tue, 2011-05-03 at 09:45 -0400, Michael Bayer wrote: It would appear as though a mapped class, I'm assuming called Preprocess, is being interpreted as an instance state, an internal ORM construct that would normally be attached to the mapped object.I'm not familiar offhand with any

Re: [sqlalchemy] Relationship wrt. inheritance problem (and suggested patch)

2011-05-16 Thread Torsten Landschoff
On Fri, 2011-04-29 at 20:14 -0400, Michael Bayer wrote: Do you want me to write a patch including a test case for the test suite? sure if you're inclined Sorry for leaving that slip. I just noticed that you fixed it and in a much better way than I would have been able to come up

Re: [sqlalchemy] AttributeError: 'Preprocess' object has no attribute 'detach' during Session.close

2011-05-16 Thread Michael Bayer
On May 16, 2011, at 3:24 PM, Torsten Landschoff wrote: On Tue, 2011-05-03 at 09:45 -0400, Michael Bayer wrote: It would appear as though a mapped class, I'm assuming called Preprocess, is being interpreted as an instance state, an internal ORM construct that would normally be attached to