This is on version 9.5, 9.6 and 10beta2. I could probably make a test-case over the weekend if I'm at home. On 21 July 2017 at 17:03, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > 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
