Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

In pg 9.3 database, table engine_configs keeps losing primary key (id) and indexes. Here is the table:

enter image description here

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_dump and 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.

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.