Hi,Recently we observed below errors while taking dump after upgrading from 9.0.13 to 9.1.9.pg_dump: schema with OID 0 does not existI referred similar issues reported previously (http://www.postgresql.org/message-id/CAGWYGjXRJj=zuGEJV0ckVn4Zf9Hb92Q+7e3aQFCVbGBMb9Z+ZQ@mail.gmail.com) and get issue resolved after identifying and inserting some of the missing rows from pg_opclass table. Below are the rows that are missed after upgrade (from pg_opclass table): 405 | aclitem_ops | 11 | 10 | 2235 | 1033 | t | 0 783 | box_ops | 11 | 10 | 2593 | 603 | t | 0 783 | point_ops | 11 | 10 | 1029 | 600 | t | 603 783 | poly_ops | 11 | 10 | 2594 | 604 | t | 603 783 | circle_ops | 11 | 10 | 2595 | 718 | t | 603 2742 | _int4_ops | 11 | 10 | 2745 | 1007 | t | 23 2742 | _text_ops | 11 | 10 | 2745 | 1009 | t | 25 2742 | _abstime_ops | 11 | 10 | 2745 | 1023 | t | 702Can some one help me to understand whether it is an issue? If not how and why these rows got disappeared after upgrade?Since we have an fully automated environment we do not encourage manual intervention. So I am trying to understand how can we handle these issues.-- Cheers,Prakash
405 | aclitem_ops | 11 | 10 | 2235 | 1033 | t | 0
783 | box_ops | 11 | 10 | 2593 | 603 | t | 0
783 | point_ops | 11 | 10 | 1029 | 600 | t | 603
783 | poly_ops | 11 | 10 | 2594 | 604 | t | 603
783 | circle_ops | 11 | 10 | 2595 | 718 | t | 603
2742 | _int4_ops | 11 | 10 | 2745 | 1007 | t | 23
2742 | _text_ops | 11 | 10 | 2745 | 1009 | t | 25
2742 | _abstime_ops | 11 | 10 | 2745 | 1023 | t | 702
pgsql-hackers by date:
Соглашаюсь с условиями обработки персональных данных