<feed xmlns='http://www.w3.org/2005/Atom'>
<title>delta/python-packages/sqlalchemy.git/lib/sqlalchemy/dialects/postgresql, branch pr/72</title>
<subtitle>github.com: zzzeek/sqlalchemy.git
</subtitle>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/'/>
<entry>
<title>- backport unique constraints reflection to 0.8.4, thereby</title>
<updated>2013-12-03T19:59:50+00:00</updated>
<author>
<name>Roman Podolyaka</name>
<email>roman.podolyaka@gmail.com</email>
</author>
<published>2013-06-09T16:07:00+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=e8458ab96b1bda5f139d34a24808167dd1f590c6'/>
<id>e8458ab96b1bda5f139d34a24808167dd1f590c6</id>
<content type='text'>
assisting with alembic installations that have upgraded and are dealing with
PG index/unique constraint reflection.

Inspection API already supports reflection of table
indexes information and those also include unique
constraints (at least for PostgreSQL and MySQL).
But it could be actually useful to distinguish between
indexes and plain unique constraints (though both are
implemented in the same way internally in RDBMS).

This change adds a new method to Inspection API - get_unique_constraints()
and implements it for SQLite, PostgreSQL and MySQL dialects.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
assisting with alembic installations that have upgraded and are dealing with
PG index/unique constraint reflection.

Inspection API already supports reflection of table
indexes information and those also include unique
constraints (at least for PostgreSQL and MySQL).
But it could be actually useful to distinguish between
indexes and plain unique constraints (though both are
implemented in the same way internally in RDBMS).

This change adds a new method to Inspection API - get_unique_constraints()
and implements it for SQLite, PostgreSQL and MySQL dialects.
</pre>
</div>
</content>
</entry>
<entry>
<title>- Fixed bug where index reflection would mis-interpret indkey values</title>
<updated>2013-10-27T22:16:42+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2013-10-27T22:14:44+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=eb58107417d1ce956e6dfc1e4f809c8d50ba6168'/>
<id>eb58107417d1ce956e6dfc1e4f809c8d50ba6168</id>
<content type='text'>
when using the pypostgresql adapter, which returns these values
as lists vs. psycopg2's return type of string.
[ticket:2855]

Conflicts:
	doc/build/changelog/changelog_09.rst
	lib/sqlalchemy/__init__.py
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
when using the pypostgresql adapter, which returns these values
as lists vs. psycopg2's return type of string.
[ticket:2855]

Conflicts:
	doc/build/changelog/changelog_09.rst
	lib/sqlalchemy/__init__.py
</pre>
</div>
</content>
</entry>
<entry>
<title>- attempt to clarify what mutable extension does for HSTORE, [ticket:2803]</title>
<updated>2013-10-18T23:35:22+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2013-10-18T23:34:58+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=bb6df3f45f0d06e0b364ea06cb9e17c04513e192'/>
<id>bb6df3f45f0d06e0b364ea06cb9e17c04513e192</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>- Removed a 128-character truncation from the reflection of the</title>
<updated>2013-10-18T23:00:29+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2013-10-18T23:00:05+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=5ae388b0773cb95f5e4e9487433a0e81e5bf8cd3'/>
<id>5ae388b0773cb95f5e4e9487433a0e81e5bf8cd3</id>
<content type='text'>
server default for a column; this code was original from
PG system views which truncated the string for readability.
[ticket:2844]
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
server default for a column; this code was original from
PG system views which truncated the string for readability.
[ticket:2844]
</pre>
</div>
</content>
</entry>
<entry>
<title>Parenthesis will be applied to a compound SQL expression as</title>
<updated>2013-10-13T00:21:38+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2013-10-13T00:21:18+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=70fdd3efa7a9a9a0fcf6cebf0853c44f04cf9a04'/>
<id>70fdd3efa7a9a9a0fcf6cebf0853c44f04cf9a04</id>
<content type='text'>
rendered in the column list of a CREATE INDEX statement.
[ticket:2742]
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
rendered in the column list of a CREATE INDEX statement.
[ticket:2742]
</pre>
</div>
</content>
</entry>
<entry>
<title>- Fixed bug in default compiler plus those of postgresql, mysql, and</title>
<updated>2013-10-13T00:13:27+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2013-10-13T00:04:55+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=d8c17e2a6f41d0aad331678e916f1aa4f07e4f7b'/>
<id>d8c17e2a6f41d0aad331678e916f1aa4f07e4f7b</id>
<content type='text'>
mssql to ensure that any literal SQL expression values are
rendered directly as literals, instead of as bound parameters,
within a CREATE INDEX statement. [ticket:2742]
- don't need expression_as_ddl(); literal_binds and include_table
take care of this functionality.

Conflicts:
	lib/sqlalchemy/sql/util.py
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
mssql to ensure that any literal SQL expression values are
rendered directly as literals, instead of as bound parameters,
within a CREATE INDEX statement. [ticket:2742]
- don't need expression_as_ddl(); literal_binds and include_table
take care of this functionality.

Conflicts:
	lib/sqlalchemy/sql/util.py
</pre>
</div>
</content>
</entry>
<entry>
<title>- put exact version string in the test</title>
<updated>2013-09-29T21:25:34+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2013-09-29T21:24:29+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=51c92e1132e48e453dda2297ffd891c8558d1d26'/>
<id>51c92e1132e48e453dda2297ffd891c8558d1d26</id>
<content type='text'>
- use match with a .* preceding instead of search
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
- use match with a .* preceding instead of search
</pre>
</div>
</content>
</entry>
<entry>
<title>Merge pull request #26 from hackop/ticket_2819</title>
<updated>2013-09-29T21:25:19+00:00</updated>
<author>
<name>mike bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2013-09-29T21:19:44+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=1e75bb2fabcb776cfdbcaf740d6d0c87989bbad6'/>
<id>1e75bb2fabcb776cfdbcaf740d6d0c87989bbad6</id>
<content type='text'>
re.match to re.search
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
re.match to re.search
</pre>
</div>
</content>
</entry>
<entry>
<title>The behavior of :func:`.extract` has been simplified on the</title>
<updated>2013-06-29T03:54:11+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2013-06-29T03:53:27+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=169c88c7a5bc1a6de9c6ec10539bb28708d3a2ce'/>
<id>169c88c7a5bc1a6de9c6ec10539bb28708d3a2ce</id>
<content type='text'>
Postgresql dialect to no longer inject a hardcoded ``::timestamp``
or similar cast into the given expression, as this interfered
with types such as timezone-aware datetimes, but also
does not appear to be at all necessary with modern versions
of psycopg2.  Also in 0.8.2.
[ticket:2740]

Conflicts:
	doc/build/changelog/changelog_09.rst
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Postgresql dialect to no longer inject a hardcoded ``::timestamp``
or similar cast into the given expression, as this interfered
with types such as timezone-aware datetimes, but also
does not appear to be at all necessary with modern versions
of psycopg2.  Also in 0.8.2.
[ticket:2740]

Conflicts:
	doc/build/changelog/changelog_09.rst
</pre>
</div>
</content>
</entry>
<entry>
<title>Fixed bug in HSTORE type where keys/values that contained</title>
<updated>2013-06-28T15:38:28+00:00</updated>
<author>
<name>Mike Bayer</name>
<email>mike_mp@zzzcomputing.com</email>
</author>
<published>2013-06-28T15:35:57+00:00</published>
<link rel='alternate' type='text/html' href='http://91.123.203.49/cgit/delta/python-packages/sqlalchemy.git/commit/?id=69179e009c2dcf71945415d455765b98ecd89fe4'/>
<id>69179e009c2dcf71945415d455765b98ecd89fe4</id>
<content type='text'>
backslashed quotes would not be escaped correctly when
using the "non native" (i.e. non-psycopg2) means
of translating HSTORE data.  Patch courtesy Ryan Kelly.
[ticket:2766]

Conflicts:
	doc/build/changelog/changelog_09.rst
	lib/sqlalchemy/dialects/postgresql/hstore.py
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
backslashed quotes would not be escaped correctly when
using the "non native" (i.e. non-psycopg2) means
of translating HSTORE data.  Patch courtesy Ryan Kelly.
[ticket:2766]

Conflicts:
	doc/build/changelog/changelog_09.rst
	lib/sqlalchemy/dialects/postgresql/hstore.py
</pre>
</div>
</content>
</entry>
</feed>
