need to pg-escape DDL sequences

[Mike Bayer]

--- a/lib/sqlalchemy/sql/compiler.py    Sun Aug 29 18:13:44 2010 -0400
+++ b/lib/sqlalchemy/sql/compiler.py    Mon Aug 30 12:37:57 2010 -0400
@@ -1121,7 +1121,7 @@
             context.setdefault('schema', sch)
             context.setdefault('fullname', preparer.format_table(ddl.target))

-        return ddl.statement % context
+        return self.sql_compiler.post_process_text(ddl.statement % context)

     def visit_create_table(self, create):
         table = create.element

we might need this for other DBAPIs as well

[Mike Bayer]

i.e.:

from sqlalchemy import *

e = create_engine('postgresql://scott:tiger@localhost/test', echo=True)

# works
e.execute(text("select foo%something"))

# doesn't work (note the %% is part of DDL)
e.execute(DDL("select foo%%something"))

# triple escaping works
e.execute(DDL("select foo%%%%something"))

[Mike Bayer]

134d78c8b44c40102afb030e6284a9d1e6acb65a

[Mike Bayer]

Removing milestone: 0.7.0 (automated comment)