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?



Wed, 10 Oct 2001 19:09:03 +0400
"Dmitry Chernikov" <cher@beltel.ru>
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.


Fri, 12 Oct 2001 10:28:43 -0400 (EDT)
Joel Burton <joel@eos.scw.org>
Re: Problem in pg_dump 7.1.2 dump order