Re: pg_dump and order of events - Mailing list pgsql-general

From Mike Mascari
Subject Re: pg_dump and order of events
Date
Msg-id 3C0598FB.B8C86721@mascari.com
Whole thread Raw
In response to pg_dump and order of events  (Dado Feigenblatt <dado@wildbrain.com>)
List pgsql-general
Dado Feigenblatt wrote:
>
> When passing a pg_dump'ed file to psql I was getting unexpected error
> messages.
> When I examined the file contents, I noticed it was trying to change
> permissions for two views that would only be created later on.
> Shouldn't pg_dump sort the order of these types of events?

The changelog
(http://developer.postgresql.org/docs/postgres/release-7-1-3.html)
for 7.1.3 reads:

..
pg_dump fixes for GRANT/REVOKE/comments on views, user-defined types
(Tom)
..

So if you get a 7.1.3 version of pg_dump your problems may be
solved.

Hope that helps,

Mike Mascari
mascarm@mascari.com

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Upcoming Presentations in Japan
Next
From: Dado Feigenblatt
Date:
Subject: Re: pg_dump and order of events