Allow initial space and \n chars in PG views

Three of the tests were failing for me.  All of them parse output from
the pg_dump command, and my version of Postgres was putting a space
before the word SELECT in the view, as well as embedded \n characters
inside of them.  I changed the regexps to permit those new
peculiarities, while still allowing everything that was previously OK.
Update RSpec to 2.99

Following the process described in
https://www.relishapp.com/rspec/docs/upgrade, so we can see
deprecation warnings before upgrading to RSpec 3.
Fixed deprecation warnings from RSpec 2.99
Ran transpec, all 33 tests pass w/o deprecations

Ran with RSpec 2.99, will upgrade to RSpec 3 and re-run tests

Output of the transpec command is below.  I did have to change the
spec in spec/named_schemas_spec.rb:178 manually.  That's the one
that transpec specifcally mentioned below.

$ transpec
Copying the project for dynamic analysis...
Running dynamic analysis with command "bundle exec rspec"...
method adapters is deprecated. use profiles instead
/Users/lrjiii/.rbenv/versions/2.1.0/lib/ruby/gems/2.1.0/gems/activesupport-4.1.1/lib/active_support/dependencies.rb:247:in `require': cannot load such file -- connection (LoadError)
  from /Users/lrjiii/.rbenv/versions/2.1.0/lib/ruby/gems/2.1.0/gems/activesupport-4.1.1/lib/active_support/dependencies.rb:247:in `block in require'
  from /Users/lrjiii/.rbenv/versions/2.1.0/lib/ruby/gems/2.1.0/gems/activesupport-4.1.1/lib/active_support/dependencies.rb:232:in `load_dependency'
  from /Users/lrjiii/.rbenv/versions/2.1.0/lib/ruby/gems/2.1.0/gems/activesupport-4.1.1/lib/active_support/dependencies.rb:247:in `require'
  from /private/var/folders/tr/rlplv_rs66g6_n32lyycyw0c0000gn/T/d20140629-74532-xm5bum/schema_plus/spec/spec_helper.rb:13:in `<top (required)>'
  from /private/var/folders/tr/rlplv_rs66g6_n32lyycyw0c0000gn/T/d20140629-74532-xm5bum/schema_plus/spec/column_definition_spec.rb:1:in `require'
  from /private/var/folders/tr/rlplv_rs66g6_n32lyycyw0c0000gn/T/d20140629-74532-xm5bum/schema_plus/spec/column_definition_spec.rb:1:in `<top (required)>'
  from /Users/lrjiii/.rbenv/versions/2.1.0/lib/ruby/gems/2.1.0/gems/rspec-core-2.99.1/lib/rspec/core/configuration.rb:1065:in `load'
  from /Users/lrjiii/.rbenv/versions/2.1.0/lib/ruby/gems/2.1.0/gems/rspec-core-2.99.1/lib/rspec/core/configuration.rb:1065:in `block in load_spec_files'
  from /Users/lrjiii/.rbenv/versions/2.1.0/lib/ruby/gems/2.1.0/gems/rspec-core-2.99.1/lib/rspec/core/configuration.rb:1065:in `each'
  from /Users/lrjiii/.rbenv/versions/2.1.0/lib/ruby/gems/2.1.0/gems/rspec-core-2.99.1/lib/rspec/core/configuration.rb:1065:in `load_spec_files'
  from /Users/lrjiii/.rbenv/versions/2.1.0/lib/ruby/gems/2.1.0/gems/rspec-core-2.99.1/lib/rspec/core/command_line.rb:18:in `run'
  from /Users/lrjiii/.rbenv/versions/2.1.0/lib/ruby/gems/2.1.0/gems/rspec-core-2.99.1/lib/rspec/core/runner.rb:103:in `run'
  from /Users/lrjiii/.rbenv/versions/2.1.0/lib/ruby/gems/2.1.0/gems/rspec-core-2.99.1/lib/rspec/core/runner.rb:17:in `block in autorun'
Coverage report generated for RSpec, [ruby 1.9.3 - ActiveRecord 4.0.6 - SQLite], [ruby 1.9.3 - ActiveRecord 4.1.1 - Mysql2], [ruby 1.9.3 - ActiveRecord 4.1.1 - PostgreSQL], [ruby 1.9.3 - ActiveRecord 4.1.1 - SQLite], [ruby 2.0.0 - ActiveRecord 3.2.18 - Mysql2], [ruby 2.0.0 - ActiveRecord 3.2.18 - PostgreSQL], [ruby 2.0.0 - ActiveRecord 3.2.18 - SQLite], [ruby 2.0.0 - ActiveRecord 4.0.6 - Mysql2], [ruby 2.0.0 - ActiveRecord 4.0.6 - PostgreSQL], [ruby 2.0.0 - ActiveRecord 4.0.6 - SQLite], [ruby 2.0.0 - ActiveRecord 4.1.1 - Mysql2], [ruby 2.0.0 - ActiveRecord 4.1.1 - PostgreSQL], [ruby 2.0.0 - ActiveRecord 4.1.1 - SQLite], [ruby 2.1.0 - ActiveRecord 3.2.18 - Mysql2], [ruby 2.1.0 - ActiveRecord 3.2.18 - PostgreSQL], [ruby 2.1.0 - ActiveRecord 3.2.18 - SQLite], [ruby 2.1.0 - ActiveRecord 4.0.6 - Mysql2], [ruby 2.1.0 - ActiveRecord 4.0.6 - PostgreSQL], [ruby 2.1.0 - ActiveRecord 4.0.6 - SQLite], [ruby 2.1.0 - ActiveRecord 4.1.1 - Mysql2], [ruby 2.1.0 - ActiveRecord 4.1.1 - PostgreSQL], [ruby 2.1.0 - ActiveRecord 4.1.1 - SQLite] to /private/var/folders/tr/rlplv_rs66g6_n32lyycyw0c0000gn/T/d20140629-74532-xm5bum/schema_plus/coverage. 272 / 650 LOC (41.85%) covered.

Gathering the spec suite data...

Converting spec/column_definition_spec.rb
Converting spec/column_spec.rb
Converting spec/connection_spec.rb
Converting spec/connections/mysql/connection.rb
Converting spec/connections/mysql2/connection.rb
Converting spec/connections/postgresql/connection.rb
Converting spec/connections/sqlite3/connection.rb
Converting spec/foreign_key_definition_spec.rb
Converting spec/foreign_key_spec.rb
Converting spec/index_definition_spec.rb
Converting spec/index_spec.rb
Converting spec/migration_spec.rb
Converting spec/named_schemas_spec.rb
The `=~ expected_names` has been converted but it might possibly be incorrect due to a lack of runtime information. It's recommended to review the change carefully.
spec/named_schemas_spec.rb:178:      Member.foreign_keys.map(&:name).should =~ expected_names
Converting spec/schema/auto_schema.rb
Converting spec/schema/core_schema.rb
Converting spec/schema_dumper_spec.rb
Converting spec/schema_spec.rb
Converting spec/spec_helper.rb
Converting spec/support/helpers.rb
Converting spec/support/matchers/automatic_foreign_key_matchers.rb
Converting spec/support/matchers/have_index.rb
Converting spec/support/matchers/reference.rb
Converting spec/views_spec.rb

Summary:

199 conversions
  from: obj.should
    to: expect(obj).to
71 conversions
  from: == expected
    to: eq(expected)
46 conversions
  from: obj.should_not
    to: expect(obj).not_to
12 conversions
  from: it { should ... }
    to: it { is_expected.to ... }
7 conversions
  from: =~ /pattern/
    to: match(/pattern/)
3 conversions
  from: =~ [1, 2]
    to: match_array([1, 2])
2 conversions
  from: lambda { }.should
    to: expect { }.to
1 conversion
  from: obj.should_receive(:message)
    to: expect(obj).to receive(:message)

341 conversions, 0 incompletes, 1 warning, 0 errors

A commit message that describes the conversion summary was generated to
.git/COMMIT_EDITMSG. To use the message, type the following command for
the next commit:
    git commit -aeF .git/COMMIT_EDITMSG

Done! Now run rspec and check if everything is green.
Upgraded to RSpec 3.0.

All of the postgresql and sqlite3 tests pass, but there are oodles of
deprecation warnings that I need to address.

Didn't run the mysql adapter tests because they are so slow on my
system, but I will run them along with the others when I fix the
deprecation warnings.
All deprecations except one are fixed

when I run all of the postgresql and sqlite3 tests.  When I fix this
last deprecation message, I will need to run the mysql and mysql2 tests.
The deprecation message that is left mentions this line:

Using `stub` from rspec-mocks' old `:should` syntax without explicitly
enabling the syntax is deprecated. Use the new `:expect` syntax or
explicitly enable `:should` instead. Called from
/Users/lrjiii/projects/schema_plus/spec/named_schemas_spec.rb:202:in
`(root)'.

or this line:

Using `any_instance` from rspec-mocks' old `:should` syntax without
explicitly enabling the syntax is deprecated. Use the new `:expect`
syntax or explicitly enable `:should` instead. Called from
/Users/lrjiii/projects/schema_plus/spec/foreign_key_spec.rb:35:in `block
(3 levels) in <top (required)>'.
Now *really* down to one deprecation message

Even though I said, in the previous commit, that there was one remaining
deprecation message, there were in fact two.  This commit fixes one of
them, with one to go.
Fixed last deprecation issue (with two caveats)

Caveat 1: Still need to test mysql and mysql2

Caveat 2: There is yet another deprecation message that appears near the
beginning of the test, which I will investigate:

method adapters is deprecated. use profiles instead
All tests pass, no deprecations.

I tested both mysql and mysql2, and they passed.  The "method adapters
is deprecated. use profiles instead" message is from the simplecov gem,
not rspec.

Ready for pull request.
Merge pull request #162 from robababa/issue-160

Issue 160 - Upgrade tests to RSpec 3.0