ahhhh! we had a crash last night on our database -- a primary key index became corrupted. so i dropped it, renamed the database, re-created the structure using the old name (with the primary key defined), and then copied the old renamed data into the new structure. found a couple of duplicates, fixed them, then ok. today in that same file we are finding it dropping records like flies! i don't understand what is going on -- it is not a complicated table (only 19 fields) and it is nowhere near the largest table in the database. we are on postgres 6.4.2, linux rh 5.2, newer kernel. any ideas?? vacuuming shows no problems now (was showing problem when the index was bad). any help you could provide would be MUCH appreciated! jt kirkpatrick / mps ************
