Implements dynamic search_path management
attempt to add failing test
add failing test

fix typos
add get primary key helper

get non-standard primary keys
get failing test to pass
add logic to pull back primary key using table name via ActiveRecord
add rails 2 compatibility
Add support for template in PostgreSQLAdapter
Fetch a sequence value manually for tables with no identity columns

This is to support legacy tables for which the sequence needs to be
manually specified in ActiveRecord
Few more changes to get migrations to run

- translate double and bigint as native types
- silence the explain feature for now
- add runstats methods
- allow running structure_dump with a default schema
- the zos? condition was too generic, make it less so
- don't sub in sub-queries
Use DECIMAL(1) for boolean fields.

Using smallint is agressive, decimal(1) is a much reasonable option for boolean fields.
We needed this because we have many smallints in our database that are NOT booleans.
Support WITH statements in select

Without this, the adapter will try to execute WITH statements using executeUpdate
sql server 2000 doesn't contain a sys.view table - fix broken test
Merge pull request #195 from gregors/view_sys_mssql_2000

sql server 2000 doesn't contain a sys.view table - fix broken test
fix row_number errors on SQL Server 2000

SqlServer2000AddLimitOffset was calling the wrong version of ReplaceLimitOffset
Running build with latest active record versions.
Using ActiveRecord 3.0.15
Appraisal required Gemfile.lock files to be pushed
mssql: Fix pessimistic locking

This fixes the error:

  ActiveRecord::StatementInvalid: ActiveRecord::JDBCError: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR.

when executing code like this:

  Entry.lock(true).all

Before, it would generate SQL like this:

  SELECT [entries].* FROM [entries]  FOR UPDATE WITH(ROWLOCK,UPDLOCK)

Now, it generates SQL like this:

  SELECT [entries].* FROM [entries]  WITH(ROWLOCK,UPDLOCK)
It should be multiple args. Thanks to @techmaniack!

We are calling this from rails.rake!
iseries returns date with two digit year, leave as string instead of breaking