Jordan Gigov <coladict@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
