Re: [sqlalchemy] bug in DDL event with %

2012-01-18 Thread Michael Bayer
you have to escape those out with %%. On Jan 18, 2012, at 3:06 AM, lestat wrote: > Hi! > > > If I create DDL like this with %: > > event.listen(db.metadata, 'after_create', DDL( >""" >CREATE OR REPLACE FUNCTION test_func() RETURNS void AS $$ >DECLARE >max_user_id INTEGER; >

[sqlalchemy] bug in DDL event with %

2012-01-18 Thread lestat
Hi! If I create DDL like this with %: event.listen(db.metadata, 'after_create', DDL( """ CREATE OR REPLACE FUNCTION test_func() RETURNS void AS $$ DECLARE max_user_id INTEGER; BEGIN SELECT INTO max_user_id MAX("id") FROM "user"; RAISE INFO 'max_user_id: (%)', max_user