delta/python-packages/sqlalchemy.git/lib/sqlalchemy/dialects/postgresql, branch pr/295 github.com: zzzeek/sqlalchemy.git 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







Merge "Refine PG inspection methods"
2016-06-06T21:29:33+00:00

mike bayer
mike_mp@zzzcomputing.com

2016-06-06T21:29:33+00:00

6bc0da30b0f238514ccfbc8ac1fb78200ee104d1












Refine PG inspection methods
2016-06-06T19:41:36+00:00

Sebastian Bank
sebastian.bank@uni-leipzig.de

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

ec2004d8c278b3aefd32c8743fe5c4d4a6c40bd4

This refines get_schema_names(), get_table_names(),
get_view_defintion(), _get_foreign_table_names(),
and get_view_names() to use better queries and
remove unnecessary explicit encoding logic.

Pull-request: https://github.com/zzzeek/sqlalchemy/pull/250
Change-Id: I7e87b29c34b97b37f21bbc83392b2274af4db0ab





This refines get_schema_names(), get_table_names(),
get_view_defintion(), _get_foreign_table_names(),
and get_view_names() to use better queries and
remove unnecessary explicit encoding logic.

Pull-request: https://github.com/zzzeek/sqlalchemy/pull/250
Change-Id: I7e87b29c34b97b37f21bbc83392b2274af4db0ab







Replace some uses of re.sub with str.lstrip/replace
2016-06-06T16:37:31+00:00

Ville Skyttä
ville.skytta@iki.fi

2016-06-06T16:37:31+00:00

9393317affc11e8545e5029cb8d55cea7e57c342

Change-Id: I98cd60b6830ee94e39ba9307523a9e8fb93bf4e8
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/280





Change-Id: I98cd60b6830ee94e39ba9307523a9e8fb93bf4e8
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/280







Add SKIP LOCKED support for Postgresql, Oracle
2016-06-02T21:46:16+00:00

Jack Zhou
univerio@gmail.com

2016-05-31T14:01:46+00:00

e8f97c9e357ed0793ce11086823f83aa4a8bb4ad

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





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