Bob Lunney writes:
> Could pg_dump also take an AccessShared lock on the system tables to prevent
> DDL changes during the dump, thereby preventing this error? Just a thought...
I think that cure would probably be worse than the disease ...
regards, tom lane
--
Sent v
Tom,
Thanks for the detailed explanation - I appreciate it. If i understand
correctly I should be able to just change the job to not drop and recreate the
indexes and the dump will run without the cache lookup error. I'll take a hit
in performance reloading the table, but I like database dump
