Sam Saffron <sam.saffron@xxxxxxxxx> writes: > Why would > "ERROR: operator does not exist: name !~ unknown" > Come up ? It's hard to explain that as anything except corrupted system catalogs in your existing database :-(. If you were really lucky, reindexing pg_operator would fix it; but since pg_operator is usually pretty static, it seems unlikely that it suffered index corruption. > Any way to work around this? Rather than relying on pg_upgrade, you could try using pg_dump(all) to extract the data. With some luck, pg_dump wouldn't be affected by whatever has happened to the pg_operator catalog. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
