Обсуждение: pg_dump issue - push useless statements REVOKE, GRANT

Поиск
Список
Период
Сортировка

pg_dump issue - push useless statements REVOKE, GRANT

От
Pavel Stehule
Дата:
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