Postgres: Do not attempt to deallocate a statement if the connection is no longer active.

'Type' is a reserved column for STI.  Changed conditions example to
avoid using that column name as an example.  The example isn't
STI-related (and mentioning STI here is needless clutter), so changing
to avoid accidentally encouraging users to use 'type' as a column name
for other purposes.

Use broken YAML that will fail with Syck as well as Psych. Fixes test_broken_yaml_exception in fixtures_test.rb on Ruby 1.8.7.

Cherry-pick from 3-1-stable: b8d46924

Only use LOWER for mysql case insensitive uniqueness check when column has a case sensitive collation.

use thread locals and an instance variable within QueryCache#BodyProxy to maintain appropriate linkage with AR database connection across threads

You can use multiple databases in your tests without disabling transactional fixtures.

An association between two models cannot be made if a relevant key is
unknown, so fail fast rather than generating invalid SQL. Fixes #3207.

This reverts commit ee2be435.

Add tests for prepared statements with multiple schemas in
postgreSQL.

To allow the use of prepared statements when changing schemas in
postgres, the schema search path is added to the sql key.

If we don't have a primary key when we ask for it, it's better to fail
fast. Fixes GH #2307.

Changing rake db:schema:dump to run :environment as well as :load_config, as running :load_config alone will lead to the dumper being run without including extensions such as those included in foreigner and spatial_adapter.

This reverses a change made here: https://github.com/rails/rails/commit/5df72a238e9fcb18daf6ab6e6dc9051c9106d7bb#L0L324

I'm assuming here that :load_config needs to be invoked separately from :environment, as it is elsewhere in the file for db operations, if not the alternative is to go back to "task :dump => :environment do".
Signed-off-by: NJosé Valim <jose.valim@gmail.com>

Leaving the path unquoted causes errors in paths containing spaces or dashes.

Closes #2807.

Fix: habtm doesn't respect select query method

Closes #3104.

CollectionProxy#replace should change the DB records rather than just mutating the array. Fixes #3020.