Problem in pg_dump 7.1.2 dump order

Started by Dmitry Chernikovover 24 years ago2 messageshackers
Jump to latest
#1Dmitry Chernikov
cher@beltel.ru

Hello,

In dump file statement which grants permissions on view exists before
statement which create view.
For tables and sequences permissions dumped in correct order.

--TOC Entry ID 124 (OID 150248)
GRANT ALL on my_view to group sales;

... skipped

--TOC Entry ID 123 (OID 194103)
CREATE VIEW my_view ...

Any comments?

#2Joel Burton
joel@eos.scw.org
In reply to: Dmitry Chernikov (#1)
Re: Problem in pg_dump 7.1.2 dump order

On Wed, 10 Oct 2001, Dmitry Chernikov wrote:

Hello,

In dump file statement which grants permissions on view exists before
statement which create view.
For tables and sequences permissions dumped in correct order.

--TOC Entry ID 124 (OID 150248)
GRANT ALL on my_view to group sales;

... skipped

--TOC Entry ID 123 (OID 194103)
CREATE VIEW my_view ...

Any comments?

This bug was fixed in 7.1.3.