rails/rails — Issue #4426: [3.1.3] PGError: ERROR:  relation does not exist
Author: ExReanimator
Created: 2012-01-12 17:30:44+00:00
State: open

Migration doesn't create table.

Migration works great, no errors.

$rake db:migrate
== CreateEvents: migrating ===================================================
-- create_table(:events)
NOTICE: CREATE TABLE will create implicit sequence "events_id_seq" for serial column "events.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "events_pkey" for table "events"
-> 0.0120s
== CreateEvents: migrated (0.0125s) ==========================================

But after that, got an error:

PGError: ERROR: relation "events" does not exist
LINE 4: WHERE a.attrelid = '"events"'::regclass
^
: SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"events"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum

And if to look into a database there is no table "events".
It's appear in production mode.