Re: percentile symbol quoting in op

2015-06-26 Thread Mike Bayer
On 6/26/15 12:23 PM, Jonathon Nelson wrote: Greetings! I am trying to use alembic to drop and re-create a PL/pgSQL function, and the function has embedded percentile (for use in RAISE but also present in comments, etc...). When rendering the upgrade as an 'offline' sql upgrade script, the

Re: percentile symbol quoting in op

2015-06-26 Thread Mike Bayer
On 6/26/15 12:49 PM, Mike Bayer wrote: On 6/26/15 12:23 PM, Jonathon Nelson wrote: Greetings! I am trying to use alembic to drop and re-create a PL/pgSQL function, and the function has embedded percentile (for use in RAISE but also present in comments, etc...). When rendering the

[sqlalchemy] ValueError from orm/persistance on db.commit()

2015-06-26 Thread Tim Pierson
Hi, I wonder if anyone can help with the below stack-trace. The code in question works perfectly under Windows to MSSQL with the following connection string (params omitted): ENGINE = sa.create_engine('mssql://DBSERVER/DB?trusted_connection=yes') but something becomes an array when the

Re: [sqlalchemy] ValueError from orm/persistance on db.commit()

2015-06-26 Thread Mike Bayer
On 6/26/15 6:42 PM, Tim Pierson wrote: Hi, I wonder if anyone can help with the below stack-trace. The code in question works perfectly under Windows to MSSQL with the following connection string (params omitted): ENGINE =

Re: [sqlalchemy] Composite foreign keys which has common parent foreign key in SQLalchemy

2015-06-26 Thread Kevin Qiu
Yes, the problem was to implement polymorphic relationship. The relationship() was a misunderstanding, I thought I need to specify it still explicitly. The user to staff is one to one relationship, so is the user to student. I changed my design so the email act as primary key instead, and set