PeterHamilton/citier — Issue #47: Citier will not allow a migration for me.
Author: grep-awesome
Created: 2012-01-04 22:49:50+00:00
State: open

Hi,
I can't get Citier to let me migrate. When I run

bundle exec rake db:migrate --trace

I get

```
-- create_view("view_authors", "SELECT people.id, type,first_name,middle_name,last_name,suffix,birth_date,gender,self_perms,other_perms,created_at,updated_at,admin FROM people, authors WHERE p
eople.id = authors.id")
rake aborted!
An error has occurred, this and all later migrations canceled:

undefined method `create_view' for #
```

I thought this

undefined method `create_view'

Might be caused by not having rails_sql_views in my gemfile, but when I add it I get a different error. That error is

undefined method `tables' for class `ActiveRecord::ConnectionAdapters::PostgreSQLAdapter'

This occurs even though I don't use PostgreSQL at all. This second issue is also documented at this address
https://github.com/aeden/rails_sql_views/issues/7