Thread: Problem in pg_dump 7.1.2 dump order

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?

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.