Rails (PostgreSQL?) implicit sequence/index warning
database-migration, migration, postgresql, ruby-on-rails
Solution
No. That's just Postgres being awesome and automatically creating stuff for you that you actually want. It's not a warning it's just an FYI
Problem
Possible Duplicate: NOTICES for sequence after running migration in rails on postgresql Application Using PostgreSQL for development & test databases (as well as production). When I `rake db:test:prepare` my PostgreSQL `theapp_test` database I get these messages for each table: ``` 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" NOTICE: CREATE TABLE will create implicit sequence "users_id_seq" for serial column "users.id" NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "users_pkey" for table "users" ... ``` I do not get these notices with `rake db:migrate` on `theapp_development`. And I haven't noticed them in production. What does it mean and should I work to get rid of them? FYI - This didn't occur in the past when I have used MySQL (or SQLite3 for that matter) for testing...