Postgres doesn't allow bind parameters to be used with CREATE SCHEMA -
it expects an identifier, not a literal value. When I try it on my
system I don't get the "E" behavior you're getting, I get :
sqlalchemy.exc.ProgrammingError: (ProgrammingError) syntax error at or
near "'foo'"
LINE 1: CREATE SCHEMA 'foo'
On Nov 10, 2008, at 6:44 AM, sector119 wrote:
>
> Hi!
>
> I use PostgreSQL and when I try to create schema I use following
> command conn.execute('CREATE SCHEMA %(s)s', {'s':s})
>
> I get raise exc.DBAPIError.instance(statement, parameters, e,
> connection_invalidated=is_disconnect)
> sqlalchemy.exc.ProgrammingError: (ProgrammingError) syntax error at or
> near "E'system'"
> LINE 1: CREATE SCHEMA E'system'
>
> Why it try to escape schema name and how to make it not to do that? :)
>
> Thanks a lot!
> >
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
