pg_dump issue - push useless statements REVOKE, GRANT - Mailing list pgsql-hackers

From Pavel Stehule
Subject pg_dump issue - push useless statements REVOKE, GRANT
Date
Msg-id CAFj8pRCOm4T1D=trDAHPn89ZVJ6V9VDWy4=_PVCT7ktnpKFP2g@mail.gmail.com
Whole thread Raw
List pgsql-hackers
Hi

I have a dump with thousands objects.I found often pattern in dump, that has not any sense. These operations has zero sense, but it decrease a database restore.

It is expected behave?

REVOKE ALL ON TABLE zobjrozp FROM PUBLIC;
REVOKE ALL ON TABLE zobjrozp FROM sitkhaso;
GRANT ALL ON TABLE zobjrozp TO sitkhaso;
GRANT ALL ON TABLE zobjrozp TO PUBLIC;

REVOKE ALL ON TABLE zppolozky FROM PUBLIC;
REVOKE ALL ON TABLE zppolozky FROM sitkhaso;
GRANT ALL ON TABLE zppolozky TO sitkhaso;
GRANT ALL ON TABLE zppolozky TO PUBLIC;

...

5000x

Regards

Pavel Stehule


pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Parallel Seq Scan
Next
From: David Fetter
Date:
Subject: Make hba available to client code