After restoring from online backup and archive xlog files, I query pg_proc using SQL: select * from pg_proc where proname = 'xxx' and oid = XXX. I got no result back, but when using SQL:select * from pg_proc where proname = 'xxx', I got what I want, and the result OID is just the one in the first SQL.Then I reindex pg_proc, retry the first SQL, the result is correct. Any one konw what is the matter? How can I solve this without reindexing the table! PS: I am using PG8.3.7 -------------- Richard 2010-08-11 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
