Siwat Siwarborvorn wrote: > - postgresql 8.3.1 compile with options Although there isn't anything that might explain this issue, you should upgrade to the latest 8.3 minor release.
> 6) Every time we fixe by reindex pg_proc_proname_args_nsp_index. Did you keep a copy of the data files? What do the corrupt pages look like? Are they empty, perhaps, or filled with garbage, or random bit flips or what? That index shouldn't be very big, so you could just copy the corresponding file from the data directory, gzip it and send it by email, so that others can take a look. Might want to check it a hex editor first to make sure there isn't anything sensitive, though. Or you can send it off-list if you prefer. Use "SELECT relfilenode FROM pg_class WHERE relname='pg_proc_proname_args_nsp_index'" to find out the filename in the data directory. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
