delta/python-packages/sqlalchemy.git/test/dialect/postgresql, branch pr/296 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)
Merge "Add ON CONFLICT support for Postgresql" 2016-06-14T19:23:17+00:00 mike bayer mike_mp@zzzcomputing.com 2016-06-14T19:23:17+00:00 cfb59ecc9bbd2f5040dd5bb8c82491851b186681 






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







Deprecate FromClause.count()
2016-06-14T15:48:04+00:00

Mike Bayer
mike_mp@zzzcomputing.com

2016-06-13T19:18:13+00:00

f38f890849700ee1bf719a31275260e2da455bc3

count() here is misleading in that it not only
counts from an arbitrary column in the table, it also
does not make accommodations for DISTINCT, JOIN, etc.
as the ORM-level function does.  Core should not be
attempting to provide a function like this.

Change-Id: I9916fc51ef744389a92c54660ab08e9695b8afc2
Fixes: #3724





count() here is misleading in that it not only
counts from an arbitrary column in the table, it also
does not make accommodations for DISTINCT, JOIN, etc.
as the ORM-level function does.  Core should not be
attempting to provide a function like this.

Change-Id: I9916fc51ef744389a92c54660ab08e9695b8afc2
Fixes: #3724







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







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







Add postgresql_tablespace option on Index
2016-06-01T21:20:41+00:00

beenje
beenje@gmail.org

2016-04-12T03:15:35+00:00

ef0da7eb66d173a487adbee96311bf4996da0556

This complements the same-named parameter
available on Table.

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





This complements the same-named parameter
available on Table.

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