Sqlalchemy-redshift

------------------

- Fix incompatibility of reflection code with SQLAlchemy 1.2.0+
(`Issue 138 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/issues/138>`_)

------------------

- Do not enumerate `search_path` with external schemas (`Issue 120
<https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/pull/120>`_)
- Return constraint name from get_pk_constraint and get_foreign_keys
- Use Enums for Format, Compression and Encoding.
Deprecate string parameters for these parameter types
(`Issue 133 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/pull/133>`_)
- Update included certificate with the `transitional ACM cert bundle
<https://docs.aws.amazon.com/redshift/latest/mgmt/connecting-transitioning-to-acm-certs.html>`_
(`Issue 130 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/pull/130>`_)

------------------

- Support role-based access control in COPY and UNLOAD commands
(`Issue 88 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/pull/88>`_)
- Increase max_identifier_length to 127 characters
(`Issue 96 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/issues/96>`_)
- Fix a bug where table names containing a period caused an error on reflection
(`Issue 97 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/pull/97>`_)
- Performance improvement for reflection by caching table constraint info
(`Issue 101 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/issues/101>`_)
- Support BZIP2 compression in COPY command
(`Issue 110 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/issues/110>`_)
- Allow tests to tolerate new default column encodings in Redshift
(`Issue 114 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/pull/114>`_)
- Pull in set of reserved words from Redshift docs
(`Issue 94 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/issues/94>` _)

------------------

- Support reflecting tables with foriegn keys to tables in non-public schemas
(`Issue 70 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/pull/70>`_)
- Fix a bug where DISTKEY and SORTKEY could not be used on column names containing
spaces or commas. This is a breaking behavioral change for a command like
`__table_args__ = {'redshift_sortkey': ('foo, bar')}`. Previously, this would sort
on the columns named `foo` and `bar`. Now, it sorts on the column named `foo, bar`.
(`Issue 74 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/pull/74>`_)

------------------

- Change the name of the package to `sqlalchemy_redshift` to match the naming
convention for other dialects; the `redshift_sqlalchemy` package now emits
a `DeprecationWarning` and references `sqlalchemy_redshift`.
The `redshift_sqlalchemy` compatibility package will be removed
in a future release.
(`Issue 58 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/pull/58>`_)
- Fix a bug where reflected tables could have incorrect column order for some
`CREATE TABLE` statements, particularly for columns with an `IDENTITY`
constraint.
(`Issue 60 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/pull/60>`_)
- Fix a bug where reflecting a table could raise a ``NoSuchTableError``
in cases where its schema is not on the current ``search_path``
(`Issue 64 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/pull/64>`_)
- Add python 3.5 to the list of versions for integration tests.
(`Issue 61 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/pull/61>`_)

------------------

- Fix breakages to CopyCommand introduced in 0.3.0:
Thanks `solackerman <https://github.com/solackerman>`_.
(`Issue 53 <https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/pull/53>`_)

- When `format` is omitted, no `FORMAT AS ...` is appended to the query. This
makes the default the same as a normal redshift query.
- fix STATUPDATE as a COPY parameter