Jordan Gigov <coladict@gmail.com> writes:
> When running pg_restore as the superuser it gives the following error
> pg_restore: [archiver (db)] Error while PROCESSING TOC:
> pg_restore: [archiver (db)] Error from TOC entry 3253; 0 320628
> MATERIALIZED VIEW DATA combined_query_data web_user
> pg_restore: [archiver (db)] could not execute query: ERROR:
> permission denied for relation first_table_in_from_list
> Command was: REFRESH MATERIALIZED VIEW combined_query_data;
What PG version is this? Can you provide a self-contained test case?
> I see no reason why the superuser would get a "permission denied"
> error.
Matview queries are run as the owner of the matview, so this isn't
as surprising as all that. But if the matview works in your normal
usage, then pg_dump must be doing something wrong, perhaps emitting
grants in the wrong order.
regards, tom lane