Erbil KARAMAN wrote:
i have over 60 tables and lots of contraints (foreign keys) - multiple_inheritance for most of the tables. i will try to reproduce it with minimum tables and inheritances. And it also doesn't happen all the time. (i'm making stress tests on indexes, and it fails with "catalog is missing X attribute(s) for relid n" when this situation occurs. then i reindex the table and it stops giving missing catalog error, and also the missing columns on pgAdmin reappears)
Oh - in that case backup your data *now* and thoroughly check your hardware. pgAdmin is failing because you are having problems on your server (which happen to be temporarily fixed by a reindex).
Regards, Dave. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend