Restore from online backup, query from pg_proc, got wrong result, please see the problem!

Поиск
Список
Период
Сортировка
От Richard
Тема Restore from online backup, query from pg_proc, got wrong result, please see the problem!
Дата
Msg-id 201008112352348437689@vip.sina.com
обсуждение исходный текст
Ответы Re: Restore from online backup, query from pg_proc, got wrong result, please see the problem!  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
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
gotwhat I want, and the result OID is just the one in the first SQL.Then I reindex pg_proc, retry the first SQL, the
resultis 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


В списке pgsql-general по дате отправления:

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: MySQL versus Postgres
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Restore from online backup, query from pg_proc, got wrong result, please see the problem!