Rails (PostgreSQL?) Implicit Sequence / Index Warning

Possible duplicate:
NOTIFICATIONS for the sequence after starting the migration in rails in the postgresql application

Using PostgreSQL to develop and test databases (as well as for production). When I rake db:test:prepare my PostgreSQL database theapp_test , 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 receive these notifications with rake db:migrate on theapp_development . And I did not notice them in production. What does this mean and should I work to get rid of them?

FYI - This did not happen in the past when I used MySQL (or SQLite3, for that matter) for testing ...

+4
source share
2 answers

No. It's just that Postgres is awesome and automatically creates things for you that you really want. This is not a warning, this is just FYI

+4
source

You can disable these messages by adding (or uncommenting) the line in config/database.yml :

 # config/database.yml development: adapter: postgresql min_messages: WARNING # this line silences those NOTICE messages 
+11
source

All Articles