# HG changeset patch # User Søren Løvborg # Date 1490606978 -7200 # Node ID 3ed43530d3b859217299f2591a5efb39592fd17b # Parent 4e40640c43e5b2a580f2f2b00cafe5c060b2c330 db: upgrade to SQLAlchemy 1.1, fixing invalid PostgreSQL SQL in User.is_default_user eea19c23b741 triggered a bug in SQLAlchemy 1.0.17, causing invalid SQL to be emitted for PostgreSQL: For the (Python) query '(x == y) == z', SQLAlchemy generates the SQL 'x = y = z'. SQLite and MySQL accepts this, but PostgreSQL does not. This bug has been fixed in 1.1. Testing and review shows no problems with 1.1 diff -r 4e40640c43e5 -r 3ed43530d3b8 setup.py --- a/setup.py Thu Apr 06 21:05:30 2017 +0200 +++ b/setup.py Mon Mar 27 11:29:38 2017 +0200 @@ -45,7 +45,7 @@ "Beaker>=1.7.0,<2", "WebHelpers==1.3", "formencode>=1.2.4,<=1.2.6", - "SQLAlchemy>=1.0,<1.1", + "SQLAlchemy>=1.1,<1.2", "Mako>=0.9.0,<=1.0.0", "pygments>=1.5", "whoosh>=2.5.0,<=2.5.7",