sequence name prefix

Rather than prefixing your table names with the schema name, add the schema you want to schema_search_path in your database.yml file. Your tables (and other database objects, such as sequences and indexes) will be created in that schema. For example, if you want your app to be located in the myapp schema:

schema_search_path: myapp,public

Be sure to include the public schema (after the myapp schema) as well.

You might want to check the database and make sure the tables you've created so far are where you think they are. They might be named "keywords.foo" (in the public schema) rather than "keywords"."foo", which is how schema + table names are actually represented in Postgres. I haven't checked how the PostgreSQL adapter quotes table and and column names, but it could be an issue.

Michael Glaesemann
grzm seespotcode net