Occasionally, I get the following error while doing a simple pg_dump (
pg_dump -U postgres -Fc -f mybackup.dmp mydb):
pg_dump: [archiver (db)] query failed: ERROR: could not open relation with OID 11072443 pg_dump: [archiver (db)] query was: SELECT pg_catalog.pg_get_viewdef('11072443'::pg_catalog.oid) AS viewdef
The dump is then aborted.
I'm using PostgreSQL and pg_dump 9.2.2 for Windows.