Dear folks,
we have a strange problem. When pg_dump'ing our database with photographs
inserted as binary large objects, we found that many indexes were unable
to be dumped; the error message complained that the particular index was
not associated with any table, and pg_dump gave up.
Now are these indexes are not created by postgres 6.3.2, but they are with
6.4.2. The index name starts with xinx followed by the oid of the BLOB.
Is this normal? Why does pg_dump fail? Please CC to both of my email
addresses as well as to the list.
Nick Urbanik, Dept. of Electrical & Communications Engineering
Hong Kong Institute of Vocational Education (Tsing Yi)
email: nicku@vtc.edu.hk, nicku@iohk.com
Tel: (852) 2436 8660, (825) 2436 8674 Fax: (852) 2436 8643