Re: [sqlalchemy] quoting problem

2013-05-08 Thread Michal Nowikowski
Thanks, SET sql_mode=ANSI_QUOTES; solved my problem. Regards, Godfryd On Wednesday, May 8, 2013 4:26:35 PM UTC+2, Michael Bayer wrote: > > > On May 8, 2013, at 12:33 AM, Michal Nowikowski > > > wrote: > > Hello, > > I'm using PostgreSQL and MySQL databases and unfortunately my table names > ar

Re: [sqlalchemy] quoting problem

2013-05-08 Thread Michael Bayer
On May 8, 2013, at 12:33 AM, Michal Nowikowski wrote: > Hello, > > I'm using PostgreSQL and MySQL databases and unfortunately my table names are > CamelCase. > I have a problems with quoting in raw queries that it works for both dialects. > > 1. following query works in MySQL and fails in Pos

[sqlalchemy] quoting problem

2013-05-07 Thread Michal Nowikowski
Hello, I'm using PostgreSQL and MySQL databases and unfortunately my table names are CamelCase. I have a problems with quoting in raw queries that it works for both dialects. 1. following query works in MySQL and fails in PostgreSQL: s = sqlalchemy.text('select max(version) from DatabaseSch