delta/python-packages/sqlalchemy.git/lib/sqlalchemy/dialects/postgresql/base.py, branch pr/311 github.com: zzzeek/sqlalchemy.git spelling: Postgresql -> PostgreSQL 2016-10-08T17:42:50+00:00 Ville Skyttä ville.skytta@iki.fi 2016-10-07T10:18:58+00:00 8c2c464cb8e1b40f90f544295afbf9a83b372eb7 






Add "eager_parenthesis" late-compilation rule, use w/ PG JSON/HSTORE
2016-10-01T13:46:11+00:00

Mike Bayer
mike_mp@zzzcomputing.com

2016-09-30T14:09:56+00:00

333414fe94941a6a58e7d8e45042548eb2d58119

Added compiler-level flags used by Postgresql to place additional
parenthesis than would normally be generated by precedence rules
around operations involving JSON, HSTORE indexing operators as well as
within their operands since it has been observed that Postgresql's
precedence rules for at least the HSTORE indexing operator is not
consistent between 9.4 and 9.5.

Fixes: #3806
Change-Id: I5899677b330595264543b055abd54f3c76bfabf2





Added compiler-level flags used by Postgresql to place additional
parenthesis than would normally be generated by precedence rules
around operations involving JSON, HSTORE indexing operators as well as
within their operands since it has been observed that Postgresql's
precedence rules for at least the HSTORE indexing operator is not
consistent between 9.4 and 9.5.

Fixes: #3806
Change-Id: I5899677b330595264543b055abd54f3c76bfabf2







Enable include_table for ON CONFLICT whereclauses
2016-09-28T22:08:30+00:00

Mike Bayer
mike_mp@zzzcomputing.com

2016-09-28T22:01:57+00:00

800a18aff2927433163afec3b7a4671eabe1c2e3

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





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







Fix table reference in PostgreSQL documentation
2016-08-28T11:22:42+00:00

Michael Williamson
mike@zwobble.org

2016-08-28T11:22:42+00:00

2b0fa0f8a190a65aea5a284e4f7d0a22488ae560












Repair PG BIGSERIAL w/ TypeDecorator, Variant
2016-07-04T20:54:01+00:00

Mike Bayer
mike_mp@zzzcomputing.com

2016-07-04T20:37:26+00:00

428dfeee48c1fc4ceb5712b8934e90132ee57e33

Some of the dialect impl memoization for TypeDecorator
necessarily keeps the top-level TypeDecorator type
around, since a user-defined type will have bind and result
set processing behavior.  For both TypeDecorator and Variant,
PG dialect needs to ensure it's looking at the SQLAlchemy
type to check for SmallInteger / BigInteger.

Fixes: 3739
Change-Id: I2d45fb997f17c6272d6bb826a77d2dba665adae7
(cherry picked from commit 421fa6b8bf9f0c3c5041579c89ec405ce0f5e0b0)





Some of the dialect impl memoization for TypeDecorator
necessarily keeps the top-level TypeDecorator type
around, since a user-defined type will have bind and result
set processing behavior.  For both TypeDecorator and Variant,
PG dialect needs to ensure it's looking at the SQLAlchemy
type to check for SmallInteger / BigInteger.

Fixes: 3739
Change-Id: I2d45fb997f17c6272d6bb826a77d2dba665adae7
(cherry picked from commit 421fa6b8bf9f0c3c5041579c89ec405ce0f5e0b0)







Add ON CONFLICT support for Postgresql
2016-06-14T19:03:14+00:00

Robin Thomas
robin.thomas@livestream.com

2016-04-14T16:57:15+00:00

4e9ab7a72f0ad506cf519069fd67127f63e5f2aa

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





Fixes: #3529
Co-authored-by: Mike Bayer <mike_mp@zzzcomputing.com>
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

Iuri de Silvio
iurisilvio@gmail.com

2016-04-27T15:27:00+00:00

31a0da32a8af2503c6b94123a0e869816d83c707

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 <mike_mp@zzzcomputing.com>
Change-Id: I597287e0ebbbe256c957a3579b58ace6848ab4f4
Pull-request: https://bitbucket.org/zzzeek/sqlalchemy/pull-requests/84





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 <mike_mp@zzzcomputing.com>
Change-Id: I597287e0ebbbe256c957a3579b58ace6848ab4f4
Pull-request: https://bitbucket.org/zzzeek/sqlalchemy/pull-requests/84







Merge "Support normal /materialized views in PG separately"
2016-06-08T17:21:12+00:00

mike bayer
mike_mp@zzzcomputing.com

2016-06-08T17:21:12+00:00

24d29a63b6a30d1f1cd4d1097c021be0302c7922












Add 'FOR NO KEY UPDATE' / 'FOR KEY SHARE' support for Postgresql
2016-06-08T15:24:57+00:00

Sergey Skopin
sa.skopin@gmail.com

2016-05-31T14:02:08+00:00

3ebd1b30eb392ff62f08f0755e79a228d61ba7d2

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

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





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

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







Support normal /materialized views in PG separately
2016-06-06T22:57:10+00:00

Sebastian Bank
sebastian.bank@uni-leipzig.de

2016-04-12T03:16:39+00:00

824c8664ed18f115fc109c46cec0c25d223f8aad

Fixes: #3588
Change-Id: Ifbfcab67375f289ddb5c4522f4b803cb8b7c34de
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/250





Fixes: #3588
Change-Id: Ifbfcab67375f289ddb5c4522f4b803cb8b7c34de
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/250