ruby-on-rails - Rails - 迁移错误 - PG::InvalidSchemaName: 错误:

Question

当我跑 rake db:migrate我收到以下错误:

ActiveRecord::StatementInvalid: PG::InvalidSchemaName: ERROR:  no schema has been selected to create in
: CREATE TABLE "schema_migrations" ("version" character varying NOT NULL) 

PG::InvalidSchemaName: ERROR:  no schema has been selected to create in

Tasks: TOP => db:migrate
(See full trace by running
ActiveRecord::StatementInvalid: PG::InvalidSchemaName: ERROR:  no schema has been selected to create in
: CREATE TABLE "schema_migrations" ("version" character varying NOT NULL) 

PG::InvalidSchemaName: ERROR:  no schema has been selected to create in

Tasks: TOP => db:migrate
(See full trace by running task with --trace) task with --trace)

我不知道如何解决它，并欢迎任何想法。

我正在运行 Rails 4。

出现这个错误是因为我最初使用的是 MySQL 数据库(工作正常)，但后来切换到 pgSQL 以允许轻松上传到 heroku。现在它既不能在本地主机上运行，​​也不能在 heroku 上运行。

Answer 1

当搜索路径中提到的架构不存在时，会发生此错误。您可能在数据库配置中配置了架构搜索路径。您可以从配置中删除架构搜索路径。如果要保留架构搜索路径，请先创建架构。