delta/python-packages/sqlalchemy.git/test/dialect/postgresql/test_compiler.py, branch pr/320

Put include_table=True for DO UPDATE..WHERE, but not ON CONFLICT

2016-11-08T03:03:16+00:00

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

Add a qualifying character to multi INSERT..VALUES parameter names

2016-10-17T16:14:41+00:00

Changed the naming convention used when generating bound parameters
for a multi-VALUES insert statement, so that the numbered parameter
names don't conflict with the anonymized parameters of a WHERE clause,
as is now common in a PostgreSQL ON CONFLICT construct.

Change-Id: I3188d100fe4d322a47d344d6a63d3e40b915f228
Fixes: #3828

Enable include_table for ON CONFLICT whereclauses

2016-09-28T22:08:30+00:00

Fixed issue in new PG "on conflict" construct where columns including
those of the "excluded" namespace would not be table-qualified
in the WHERE clauses in the statement.

Change-Id: Idfefc93e7e7b0d84805e23d5436d822d606f6a0a
Fixes: #3807

Add ON CONFLICT support for Postgresql

2016-06-14T19:03:14+00:00

Fixes: #3529
Co-authored-by: Mike Bayer 
Change-Id: Ie3bf6ad70d9be9f0e44938830e922db03573991a
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/258

Support `postgresql_concurrently` on index dropping.

2016-06-08T18:41:05+00:00

Also adds version detection so that DROP INDEX CONCURRENTLY
only renders if the Postgresql version is 9.2 or higher;
for CREATE INDEX CONCURRENTLY, version detection is added
to allow the phrase to omit if the Postgresql version is
less than 8.2.

Co-authored-by: Mike Bayer 
Change-Id: I597287e0ebbbe256c957a3579b58ace6848ab4f4
Pull-request: https://bitbucket.org/zzzeek/sqlalchemy/pull-requests/84

Add 'FOR NO KEY UPDATE' / 'FOR KEY SHARE' support for Postgresql

2016-06-08T15:24:57+00:00

Adds ``key_share=True`` for with_for_update().

Co-authored-by: Mike Bayer 
Change-Id: I74e0c3fcbc023e1dc98a1fa0c7db67b4c3693a31
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/279

Add SKIP LOCKED support for Postgresql, Oracle

2016-06-02T21:46:16+00:00

This adds `SELECT ... FOR UPDATE SKIP LOCKED`/
`SELECT ... FOR SHARE SKIP LOCKED` rendering.

Change-Id: Id1dc4f1cafc1de23f397a6f73d54ab2c58d5910d
Pull-request: https://bitbucket.org/zzzeek/sqlalchemy/pull-requests/86

Add postgresql_tablespace option on Index

2016-06-01T21:20:41+00:00

This complements the same-named parameter
available on Table.

Fixes: #3720
Change-Id: I56e081e2a551f37c3f392ca4b301c9ef82b94e59
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/233

- Multi-tenancy schema translation for :class:`.Table` objects is added.

2016-01-09T03:12:25+00:00

This supports the use case of an application that uses the same set of
:class:`.Table` objects in many schemas, such as schema-per-user.
A new execution option
:paramref:`.Connection.execution_options.schema_translate_map` is
added. fixes #2685
- latest tox doesn't like the {posargs} in the profile rerunner

Merge remote-tracking branch 'origin/pr/216'

2015-11-30T18:02:39+00:00