Re: [sqlalchemy] Possible 1.0 regression or geoalchemy2 issue

2015-07-01 Thread Troy Toman
I built 1.0.7dev from source and can verify that it resolved the issue we were seeing. Thanks! Troy On Wednesday, July 1, 2015 at 12:20:17 PM UTC-5, Michael Bayer wrote: resolved in master / rel_1_0 On 7/1/15 1:01 PM, Mike Bayer wrote: after two reports, it is: https

[sqlalchemy] Possible 1.0 regression or geoalchemy2 issue

2015-07-01 Thread Troy Toman
I am seeing a behavior similar to Issue #3402 but it exists in SQLAlchemy 1.0.6 and it involves using geoalchemy2. I have filed an issue there but since it is behaving differently in sqlalchemy 0.9.3, I wanted to raise it here as well. Test program: import geoalchemy2 from sqlalchemy

[sqlalchemy] Re: Differentiate ANSIIdentifierPreparer.format_column select clause from where clause??

2007-02-19 Thread Troy
, MS-SQL, Sybase -- case does not matter. In Postgres, Oracle and DB2 it does. DB2 and Oracle (since version 10 I think) have some server-side settings to help, but Postgres does not. Assuming I have a table named people: fname lname = Troy Kruthoff albert

[sqlalchemy] Re: Differentiate ANSIIdentifierPreparer.format_column select clause from where clause??

2007-02-19 Thread Troy
be missing something, or maybe not. At first, our unit tests all passed, then when we added real world data with mixed case, tests started to fail on everything doing sorts and where's on character data. How about a Pepsi (at PyCon)? Troy --~--~-~--~~~---~--~~ You

[sqlalchemy] Re: Asynchronous SQLAlchemy--Anybody using Twisted, sAsync?

2007-02-19 Thread Troy
We did a quick proof-of-concept with it and it appeared to work as advertised :) Troy On Feb 19, 10:11 am, Matt Culbreth [EMAIL PROTECTED] wrote: Howdy Group, I'm playing out with a few things now and I wanted to see if anyone else has used SQLAlchemy in an asynchronous manner

[sqlalchemy] Re: Getting list of referencing table

2007-02-19 Thread Troy
I believe this is what your looking for (from the sqlalchemy recipes section of the wiki) http://www.sqlalchemy.org/trac/wiki/UsageRecipes/DependentTables Troy On Feb 19, 12:11 am, Andreas Jung [EMAIL PROTECTED] wrote: Is there a way to get a list of tables or table names that reference

[sqlalchemy] Re: Differentiate ANSIIdentifierPreparer.format_column select clause from where clause??

2007-02-18 Thread Troy
to release. Thanks, Troy P.S. This is my second response, I'm using the google groups web UI and it appears that my replies are not being posted (I checked a few other threads that I have replied to here, and at the Mako group). Not sure why, it says from me to sqlalchemy, but I apologize if your

[sqlalchemy] Differentiate ANSIIdentifierPreparer.format_column select clause from where clause??

2007-02-16 Thread Troy
residing in alchemy's databases module, i.e. : pg_db = create_engine('myapp.database.postgres://scott:[EMAIL PROTECTED]: 5432/mydatabase') Thanks, Troy --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group

[sqlalchemy] Re: Function Indexes

2007-02-13 Thread Troy
A common use of functional indexes for Postgres and Oracle is to apply a upper or lower to a character column for case insensitive searching and ordering. For example, with the following people table: id name -- 1 adam 2 Troy select name from people where