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

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

- Postgres: Do not prefix table with schema in: "FOR UPDATE of "

2015-11-24T18:58:50+00:00

For example, this query:

    SELECT s1.users.name FROM s1.users FOR UPDATE OF s1.users

should actually be:

    SELECT s1.users.name FROM s1.users FOR UPDATE OF users

fixes #3573

fix postgresql exclude contraint to check when= against None rather than bool eval

2015-11-23T18:22:50+00:00

- add PG-specific aggregate_order_by(), references #3132

2015-08-27T14:32:21+00:00