In pg 9.3 database, table engine_configs keeps losing primary key (id) and indexes. Here is the table:
For the table shown above, we just added the primary key again and it is showing integer in column ID instead of serial. There were primary key and a few indexes for table
engine_configs. There were only a few
pg_restore on the table before we found that primary key and indexes are missing again. Before that, we had manually created key and indexes on the table and verified that those key and indexes did existing. Is there any explanation of why this happened and how to prevent it from happening again? This problem literally blows up our rails 3.2 app.