Re: pg_dump and order of events

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