pg_dump issue - push useless statements REVOKE, GRANT

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: pg_dump issue - push useless statements REVOKE, GRANT
Date: 2015-01-28 20:42:54
Message-ID: CAFj8pRCOm4T1D=trDAHPn89ZVJ6V9VDWy4=_PVCT7ktnpKFP2g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-hackers by date

  From Date Subject
Next Message David Fetter 2015-01-28 20:49:31 Make hba available to client code
Previous Message Jim Nasby 2015-01-28 20:36:58 Re: Parallel Seq Scan