]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
Put include_table=True for DO UPDATE..WHERE, but not ON CONFLICT
authorMike Bayer <mike_mp@zzzcomputing.com>
Tue, 8 Nov 2016 02:41:11 +0000 (21:41 -0500)
committerMike Bayer <mike_mp@zzzcomputing.com>
Tue, 8 Nov 2016 03:03:16 +0000 (22:03 -0500)
commit942c2429c033255979b6a55de836b9b26370673e
tree6d0d97312a67814cda5d39cf23d09b1360b5884b
parentc4a8afa4c6bf5e76c24e8ed0b5c11acc0c8904e3
Put include_table=True for DO UPDATE..WHERE, but not ON CONFLICT

Fixed regression caused by the fix in :ticket:`3807` (version 1.1.0)
where we ensured that the tablename was qualified in the WHERE clause
of the DO UPDATE portion of PostgreSQL's ON CONFLICT, however you
*cannot* put the table name in the  WHERE clause in the actual ON
CONFLICT itself.   This was an incorrect assumption, so that portion
of the change in :ticket:`3807` is rolled back.

Change-Id: I442d8629496a8e405b54711cfcf487761810ae8a
Fixes: #3846
Fixes: #3807
doc/build/changelog/changelog_11.rst
lib/sqlalchemy/dialects/postgresql/base.py
test/dialect/postgresql/test_compiler.py
test/dialect/postgresql/test_on_conflict.py