首页 > 解决方案 > PG::UndefinedTable:错误:关系“房间”不存在

问题描述

我刚刚从 Sqlite3-local 迁移到 heroku 上的 Postgresql。我的一个工作正常的视图现在显示以下错误:

PG::UndefinedTable: ERROR: relation "rooms" does not exist LINE 8: WHERE a.attrelid = '"rooms"'::regclass ^ : SELECT a.attname, format_type(a.atttypid, a.atttypmod), pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod, c.collname, col_description(a.attrelid, a.attnum) AS comment FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_collation c ON a.attcollation = c.oid AND a.attcollation <> t.typcollation WHERE a.attrelid = '"rooms"'::regclass AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attnum

控制器很简单:

def index
@rooms = Room.all
end

控制台显示以下内容:

ActiveRecord::StatementInvalid (PG::UndefinedTable: ERROR:  relation "rooms" does not exist)
LINE 1: SELECT  "rooms".* FROM "rooms" LIMIT $1
                               ^
: SELECT  "rooms".* FROM "rooms" LIMIT $1

房间表在数据库中,事件包含一些虚拟数据。请问有人熟悉这个问题吗?谢谢。

标签: ruby-on-rails

解决方案


推荐阅读